Query for dates within a current Month

T

Tim

Well,

I have 4 columns in the query that show date information.
If any of them are in the same month, then I would like to
display the related feild and the date. I would include
the table but I am not sure how to do that..
-----Original Message-----
You can use the following expression in your query
where "Date" is the field: Month([Date])=Month(Now()).
-----Original Message-----
Hello,

I have a Table with multiple fields. In some of those
feilds are dates for maintenance of variuos systems. I
would lie to have a query that will pull any field within
the current month.

I have no Idea how to do this.

Thanks for any help.
.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top