Cwittmaack
Registered User.
- Local time
- Today, 05:16
- Joined
- Nov 3, 2009
- Messages
- 70
I have a database with multiple Tables, Months January – December and reports for each month. Currently it totals up the number and type transaction and prints a total of the transactions, the customer number is printed only once with the Sum Total of transactions for that month. I wanted to replace all the Monthly tables and Reports with just one table and a single report (Printed by Month)
My Problems is that when I add the Date field into the Query It lists the customer number multiple times instead of one time with the totals. ( customer 00013 conducted 16 transactions for the month of January it will list all 16 times instead of only one time with the totals). It does pull only the Month selected.
Customer number field:
Under Total: is Group By
Date Field:
Under Total: is Group By
Criteria: [Enter Beginning Date] And [Enter Ending Date]
Thank you.
My Problems is that when I add the Date field into the Query It lists the customer number multiple times instead of one time with the totals. ( customer 00013 conducted 16 transactions for the month of January it will list all 16 times instead of only one time with the totals). It does pull only the Month selected.
Customer number field:
Under Total: is Group By
Date Field:
Under Total: is Group By
Criteria: [Enter Beginning Date] And [Enter Ending Date]
Thank you.