Current Month query

[Spursman]

I have a database that logs equipment and the Cal Due Dates. It is
entered in the Short Date format. What I want to do in the query is to
select only those records that correspond to the current month since
there are records for the whole year. How would I code it to select
only the records that correspond to the current month?

Tim

 

[R. Hicks]

If you want to return the records for the current month based on the
computer's current date ... use the following as the criteria in the
date field in your query ....

Code:

 

[Spursman]

Ricky, that worked great, I appreciate it. I wish I knew what everything
on there meant though. Is there some source that has instruction on
these codes?

Also, The sort works great, but how to change it so that while it sorts
records based on the current month, the display of the records has all
the date on it (i.e. the Short Date format).

Thanks again.

Tim

 

[R. Hicks]

Just see the DateSerial() function in Access help files ...
I think if you study what the function does .. it will become much
clearer.

If the date is not appearing as you want it to appear ..
You can format the value at control level on the form or report ...
... or create a field expression in the query to output the date in the
format you need.

RDH