First of the month in queries

  • Thread starter Thread starter norm
  • Start date Start date
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
 
You can use the DateSerial function as in this example ...

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