View Single Post
 
Old 07-01-2022, 05:28 AM
Jules90 Jules90 is offline Windows 8 Office 2013
Novice
 
Join Date: Apr 2019
Posts: 24
Jules90 is on a distinguished road
Question How to enter dates between ? and ? in the criteria section of a database?

Hello,
I’m learning about Database functions – specifically DSUM - and I’m stuck at how to enter in the ‘criteria section’ dates between e.g. Sum of sales from 18th October 2014 to 17th October 2015.

I’ve set up the criteria section at the top of the worksheet, above the data table, with several blank lines to enter the criteria into.

One of the fields in the data table is ‘Order Date’ with a list of dates.

I’m not sure how to enter the criteria I’m looking for, as its between two dates, and I’m not sure how to format this correctly.

Any help would be greatly appreciated. Thanks in advance.
Cheers
Reply With Quote