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..
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.
.