1. Registered User
Join Date
Mar 2004
Posts
56

Hoping someone out there can help me with this one. here is my situation.

I have 3 fields

field 1 = customer number
field 2 = a numeric variable (Amount purchased if you will)
field 3 = 3 variables A, B, or C

A= Apples
B= Pears
C= Oranges

Customer 1 – 1 – A
Customer 2 – 5 – B
Customer 2 – 7 – C
Customer 3 – 3 – B

In Field 3, given that in any row I can have either an A, B, or C I need to have, either via query or report, a way of filtering into a report that will list say Customer 2 as having purchased a total of 5 pears and 7 Oranges.

I hope that makes proper sense, I am still learning this package and I appreciate any help given ahead of time

2. Purveyor of Discontent
Join Date
Mar 2003
Location
The Bottom of The Barrel
Posts
6,102
Set a grouping level for you report to field 1.

Then you can set three combo boxes in the footer of the grouping level to:

=SUM(iif([column 3] = "A", 1, 0))
=SUM(iif([column 3] = "B", 1, 0))
=SUM(iif([column 3] = "C", 1, 0))

3. Registered User
Join Date
Mar 2004
Posts
56
Thank you kindly, but I dont understand what you mean by set a grouping level?

4. Purveyor of Discontent
Join Date
Mar 2003
Location
The Bottom of The Barrel
Posts
6,102
I see... you may want to pick up a beginners book if you want to get the most out of access. It's a bit difficult if you have zero exposrue at all.

5. Registered User
Join Date
Mar 2004
Posts
56
I am sorry, its been a very long time for me but remembered 3 mins after reading it a few times to jar the ole memory, I did as you suggested and it works great!

Now I just need to get the format as for output. Thanks much for your patients

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•