Originally Posted by
Engr. Clement
I have a database that gives me a kind of daily sales report.
I want a situation where the access database will be able to summarise my daily sales and pick the content to another table base on that day's date.
Can any body direct me on what to do.
Thanks
Engr. Clement
If you are wanting to select record do the current date try using:
Code:
Where [YourDateField] = Date()
if you want a range, for example the previous seven days you could use:
Code:
Where [YourDateField] Between ( Date() - 7 ) and ( Date() - 1)