Search results

In my form I have a sub/form which is based off a query just showing a few fields from the customers table. I can type a filter into my main form which affects the subform using the VBA code: Private Sub cmdFilter_Enter() Me.frmCustomerListing.Form.Filter = "tblCustomers.Firstname LIKE '*"...

In my criteria for my query I need it to return results between 6th June 2007 and 23rd June 2008 (inclusive). The catch is that after 23rd June 2008, the criteria should return results between 6th June 2008 and 23rd June 2009! Is this possible or will I have to edit the criteria manually? The...