group problem, crxir2

[Former Member]

I have question.

Use access2000.mdb and CRXIR2.

my database:

country

us

uk

japan

eur

korea

china

germany

I can use "Group" function to show all

GH1, D, GF1

But I want to show that output/report is this styles

GH1, D, GF1, GH2, D, GF2,

mean: us/uk/eur/germany Group1

japan/korea Group2

china Group3

us

uk

eur

germany

..................sum of group1 only

japan

korea

.................sum of group2 only

china

.................sum of group3 only

total sub. calc total.

how to handle this case?

any advice please!

[DellSC]

I would create a formula that looks something like this:

If {MyTable.Country} in ['us','uk','eur','germany'] then 'Group1'

else if {MyTable.Country} in ['japan', 'korea'] then 'Group2'

else if {MyTable.Country} = 'china' then 'Group3'

else 'Unknown'

Group on this formula and you should be able to get the format and sums you're looking for.

-Dell

[Former Member]

thanks, It is helpful,

I have one OUTPUT example.

can you help me make simple sample to me?

https://www.sendspace.com/file/3o27up

filename is "dummdb.rar" , include access2000.mdb and output report screen picture.

many thanks!