Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

crosstab query

Status
Not open for further replies.
cochise

cochise

Technical User
Joined
Mar 27, 2001
Messages
171
Location
US
I have a table with invoicenum, invoiceamt, invoicedate

I'm trying to setup a crosstab query that will give me invoice count and total sales for each month. What do I put in the criteria?
 
Sort by date Sort by votes
Under any of those fields in the cretria put:

count()

and for the sum under invoiceamt

sum()
"ACCESS ADDICT"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question Question
Delete query takes FOREVER to run
Replies
11
Views
1K
jedraw
jedraw
Moss100
  • Locked
  • Question Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
454
dhookom
dhookom
BradCustom
  • Locked
  • Question Question
Convert Access query to SQL query
Replies
5
Views
543
strongm
strongm
Bill6868
  • Locked
  • Question Question
Query Expression Question
Replies
3
Views
417
Andrzejek
Andrzejek
mwiinde
  • Locked
  • Question Question
How to Convert Ms Access query data into Json String
Replies
0
Views
550
mwiinde
mwiinde

Part and Inventory Search

Sponsor

Back
Top