Dates

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a query that pulls all records in a date range but
when it prints the report it prints a sheet for every
date that a record is entered. I think I can get around
this if someone can tell me how to make the query only
look at the month field and the year field in the date.
That way if I enter 3 for march it will print only one
record for march and not a record for each date in march
Thanks Tom
 
Select ID, SomeDate where Year(SomeDate) = Year(date) and Month(SomeDate) =
Month(Date)

This example pulls using the current year and month. Tweak as needed.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top