How to use group by as criteria for the append query

S

subbu

Hi,
I have a requirement to sum up values for a particular
month.This has to be done for the previous 13 months
including the current one.How to give the criteria for the
query
 
D

Duane Hookom

You can total either by "a particular month" or the "previous 13 months"
quite easily with a totals query. Getting both totals is a little more
difficult and I'm not sure what exactly you are asking for.
 
S

subbu

Thanks Duane.It worked great.I was just looking for the
same.One more question.How to specify expression to get
the date range for the previous thirteen months

subbu
 
D

Duane Hookom

Please take the time to type about 10 records into the body of a message and
then the desired final display.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding data to MS Access from csv file 0
Group By problem 2
Migrate Power Bi Tenant to Office 365 Step by Step Guide or best route to take 0
How to use/create code in MS Word to calculate age? 0
Use TODAY() function as the criteria in a SUMIF formula 1
query to show where no data in a stated column 0
Current Record in multi record form as criteria for query 0

Top