Quick easy stuff needed for query buil

[ct2013]

Hi.
Another dead easy simple question!

Got a query.
Trying to use the sum option.
I have records in a table that are showing charges.
E.G. 8/12/15 £6
9/12/15 £15

I want the sum to add all these up but using a criteria of between [start date] and [end date].
What i receive when i run the query is:

8/12/15 £6
9/12/15 £15

I want that it should show me if i place between 8/12/15 and 10/12/15 a total of £21.

Thanks again!

 

[Ranman256]

Uncheck the date. If checked it will show. You just wAnt the date range in it, but don't show it.

 

[ct2013]

Thanks for prompt reply. Tried that but doesnt seem to help!

 

[Galaxiom]

Change the "Group By" to "Where" on the date field.

 

[jdraw]

Show the query SQL you are using.