Need a List and a Total in Query - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Need a List and a Total in Query

Mark Fannin

8 months ago

I have a table of order numbers by date. I used a parameter query to obtain the order numbers between two dates - no problem. Now I need to know the total number (summed up) of orders in the same query. So, if I have a list of orders, I need to have a total number. Somehow this escapes me. Thanks in advance.

	Raymond Spornhauer @Reply 8 months ago
Create a second query based on your first query and make it an aggregate query. -Raymond

	John Valencic @Reply 8 months ago
Maybe this Tech help video on Age Demographics is what you're looking for.. https://599cd.com/blog/display-article.asp?ID=2464

	Mark Fannin OP @Reply 8 months ago
I thought about that but was wondering if there was a way to get it all in one query. Thanks for the reply.

	Kevin Robertson @Reply 8 months ago
I would build a Continuous Form with you Query as the Record Source and display the Count in the Form Footer.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View