Date Query

[demon147]

I want to build a query to always reflect the current day of activity. We have a database that is used to request cheques from our headquarters and at the end of the day I want to be able to print a report based on the query that will only show what happened on the current day.

I am familiar with queries and reports as well as some Access VBA.

Help Appreciated

George

 

[rhnewfie]

You can use the Now() function for the query or the Date() function:

Select columnames from tablename where date = Now()/Date();

Now() gives dd/mm/yyyy/hh:mm:ss
Date() gives dd/mm/yyyy

HTH

RHNewfie There are 3 Types of People in the World
Those Born to Think Logically
Those that can Learn to Think Logically
Those that Shouldn't Try