Header Grouping on Form

[Eddy]

Hi all

I want to show the data on Form/subform with the Grouping function. (The
Header Grouping function on Report)

I know there is no such function on Form, but is there any alternative
solution can simulate it? (I just need one level grouping, and I don't need
to modify/add any data on that form)

Thanks
Eddy

 

[scubadiver]

Base the form on a totals query and set the form's data properties
appropriately.

 

[Eddy]

I cannot catch your suggestion. May be my question is not clear, I'm here
show an example:

-- Data --
Country City No_of_EE
-------------------------------------
CHN HK 10
CHN BJ 20
CHN SH 15
USA NY 30
USA WT 20
JPN TK 10

-- Display --
City No_of_EE
----------------------
BJ 20
HK 10
SH 15
CHN Total 45

NY 30
WT 20
USA Total 50

TK 10
JPN Total 10

It's very easy to handle on Report by the Header/Footer Grouping, but I need
to display them on Form.
Any idea?

Thanks
Eddy

 

[scubadiver]

Right!

Forms don't work like that unfortunately. An alternative suggestion is still
base the form on a query to get it looking like this:

CHN BJ 20 45
CHN HK 10 45
CHN SH 15 45
USA NY 30 50
USA WT 20 50
JPN TK 10 10

SELECT Table1.country, Table1.city, Table1.number,(SELECT Sum(X.number) FROM
table1 As X WHERE X.country = table1.country) AS Totals
FROM Table1;

 

[Peter Hibbs]

Eddy,

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

 

[Eddy]

Thanks Peter

Your suggestion is much much better and helpful.

Eddy