G
Guest
I have set up an access queries with data ranging from year 2001 - 2007, the
date criteria of the query is based on a Form.
I want to set the form with Months selection only (no date or year) and when
I run the query, the program will automatically select all the data that
falls within the months selected for all year. i.e. if I select Feb to Mar,
the query will filter the data and obtain all record between Feb and Mar of
every year from 2001-2007. Is this possible? Can anyone will me any insight
or hints on how to set this up?
date criteria of the query is based on a Form.
I want to set the form with Months selection only (no date or year) and when
I run the query, the program will automatically select all the data that
falls within the months selected for all year. i.e. if I select Feb to Mar,
the query will filter the data and obtain all record between Feb and Mar of
every year from 2001-2007. Is this possible? Can anyone will me any insight
or hints on how to set this up?