John,
I don't have a field that has a date value in my table. I only have a field
called fiscal month and it is a text value (January, February, March etc.).
The table only has 2008 transactions and next year, a new table will be
created. So I want to run a query that will return transactions where the
FiscalMonth field is equal to October. When fiscal November starts, the
query needs to pull only records that have November in this field.
Thanks,
My suggestion has nothing to do with a date field in the table.
A criterion on the field of
=Format(Date(), "mmmm")
will look at the computer clock, determine today's date, and format it as the
name of a month. That is, if you use this as a criterion in a query run today,
it will find all records where the FiscalMonth is equal to "October"; if you
run it this coming Wednesday, it will find "November".
If you want the computer to automatically determine the name of the current
fiscal month, as of today, you will have to tell us how you calculate the
fiscal month. You haven't said, and nobody here can possibly know.