create select query to sum values in between dates

[simonplus]

Hello Friends!

Need to create a select query to sum sales figures in between dates.

How can I do that?

Thanks.

[alansidman]

Assuming three fields in Table1: ID, Sales, SalesDate
Want all sales between 1/1/2016 and 1/4/2016

SELECT Table1.Sales, Table1.ID, Table1.SalesDate
FROM Table1
WHERE (((Table1.SalesDate) Between #1/1/2016# And #1/4/2016#));

If you want the total, then click on the Sigma in the ribbon after running the query.

[simonplus]

Thank you so much.

I am not sure I told you but I am a novel to Access. Where do I put the line of code?

Thanks again

[alansidman]

You will need to create a query. This is a SQL statement and not code. You will need to use this as a guide as your field names and tables may not be the same.

https://support.office.com/en-us/art...d-c29c276ee6b0

https://www.youtube.com/watch?v=QRQhBVF-6Ng

This is the SQL statement equivalent to building the query in the QBE