Help with Query Please

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.
 
Add the Customer Number again and change the Total: to Count. For the Date Field ( I hope you are not using Date as a field name...it's a reserved word) change the Total to Where. That should do the trick
 
Scooterbug
Thanks for the help that gives me a complete total I can use that in my report, but I need a breakdown by customer number which is the Dlr_Num

This is what I’m working on.
Table Fields

Dlr_Num Text Index Dup Ok. (Will have multiple entry’s )
New_Acct Number
Disconnect Number
Dlr_Access Number
Transfer Number
Entry_D Date/Time (System Date) Information was put into the computer

Query

Dlr_Num
Sum Of New_Acct
Sum Of Disconnect
Sum Of Dlr_Access
Sum Of Transfer
Entry_D

Example of report.
Dealer Number New Accounts Disconnected Dealer Access Transfer

00005 2 0 1 0
00007 0 2 0 0
00196 1 4 0 2
00209 10 14 0 0
 
Last edited:
Sorry the alinment would not take. on the report section.
 
If you want to tally up the Number of instances, then you want the count, not the sum. So the query should look like this:

Code:
[FONT=Times New Roman][SIZE=3]Group By: Dlr_Num
Count of: [/SIZE][SIZE=3] New_Acct[/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]Count of: Disconnect[/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]Count of: Dlr_Access[/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]Count of:  Transfer[/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]Where: Entry_D[/SIZE][/FONT]
 
Thanks Scooterbug, it is working great, again thank you. This will save me a lot of work.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom