Current month

[Fay Yocum]

I am creating a desktop shortcut so that the secretary can click the button
and access a report that has the classes and their rooms listed. How do I
make it give only the current month? Thank you. I am using Access03.

 

[Fay Yocum]

Thank you I will put this to use. Fay

In your query add a criteria to the date field of...

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

That will automatically roll over each month and work for a month of any
length and at the year end boundaries.

 

[Rick Brandt]

I am creating a desktop shortcut so that the secretary can click the
button and access a report that has the classes and their rooms
listed. How do I make it give only the current month? Thank you. I am
using Access03.

In your query add a criteria to the date field of...

= DateSerial(Year(Date()), Month(Date()), 1)

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

That will automatically roll over each month and work for a month of any length
and at the year end boundaries.