First of the month in queries

N

norm

I have several queries that look at a particular table that is imported the
first of every month, the queries then run and will give an inventory of
specific categories in the table. Right now I manually edit all the queries
to reflect my "D/L Date" field to the first of every month, but the queries
are getting to be many..and there is crosstabs quries involved also...what I
would like to do is have my "D/L date" field to default to the first day of
the current month that we are in..
Thanks in adavance for your help
 
B

Brendan Reynolds

You can use the DateSerial function as in this example ...

SELECT tblTest.*, DateSerial(Year(Date()),Month(Date()),1) AS FirstOfMonth
FROM tblTest;
 
Top