Can you do this in a query?

[vince99]

I have created a query that will return a total for a particular field that I have created....

I want to create another query (same as above) but I would like for the user to enter a date and only have the totals for that date returned....

This is how I built the query...

1) a query will return all fields from a table...
2) this query is built on query 1, and will return the sum of the total column in query 1

3) this query will return totals and date, but it doesnt work...

what I did is copy the 2) query, and add the date field to it, and for criteria i used

Between [date] and [date]

it doesnt work ....

any ideas?

thanks

 

[Tim1]

Check the SQL that Access has written for your last query. You need to make sure that the date field has been included in the GROUP BY clause at the bottom. If it has, can you copy the SQL into another message....

Otherwise, what you have done sounds OK

 

[vince99]

I dont know what happened, but it works now...

Thanks