I have a query that is based on date criteria. For example if someone enters the date 10/12/03 it will bring all records from 1/1/2000 - 10/12/03. I would like to create a formula so if someone enters a date, it will bring records for that month. For example if someone enters the date 10/12/03 records will show for the month of October.
Any help would be appreciated. Thank you!