Separate date field

[Guest]

I know this is simple...I have a date field in a table and need to run a
report that shows the current month. I don't think I need to separate the
date and store that in a field, I just need to be able to run a report for
the current month to show orders due

 

[Alex White MCDBA MCSE]

your recordsource for the report needs to be something like

select * from TblTest Where month(myDateField)=month(now)

 

[John Vinson]

I know this is simple...I have a date field in a table and need to run a
report that shows the current month. I don't think I need to separate the
date and store that in a field, I just need to be able to run a report for
the current month to show orders due

One way is to use the Month() function; another - that takes advantage
of indexing on the date/time field - is to use a criterion of

= DateSerial(Year(Date()), Month(Date()), 1) AND < DateSerial(Year(Date()), Month(Date()) + 1, 1)

John W. Vinson[MVP]