totals between two dates

  • Thread starter Thread starter beppe005
  • Start date Start date
B

beppe005

I have a query with the following fields: date, invoice, client, expenses,
hours.
I need to know the total of the invoice (and expenses and hours) between two
dates (the dates will be eneterd with a parametric query).

I already made a parametric query for "client" and for "date", but my
problem is that with "date" I get the dates' list (every row is a different
date) and not the total, I need only to know the amount of "invoice",
"expenses" and "hours" between the two choosen dates.

Thanks is advance.

Beppe
 
Have you been using a "Totals" query?

Could you post the SQL statement of your query?
 
You can't display the dates in the result and you need to change the totals
choice under the date field to WHERE instead of Group By.
 
John Spencer (MVP) said:
You can't display the dates in the result and you need to change the totals
choice under the date field to WHERE instead of Group By.
Click to expand...


Thank you, it worked (it took me a little while to figure it out, didn't
know the "where" thing).

Beppe
 

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

Query Help Please 3
Query with two Tables with date filed for Date Range 1
Query using two separate query totals 3
Date question formula 4
Date that falls between 2 other dates 3
Query with two date field for Date range 3
Extract data from previous week, previous two weeks, etc. 2
Errors in Report total fields 19

Back
Top