Access 2007 query between two dates
Posted on 2010-09-14
This is the first time I have ever tried to query for something other than an exact value found in a table. I simply have 4 fields Name, Hours, StartDate, EndDate. I would like to be able to enter any of the following criteria and return records matching the criteria. My difficulty is that I don't know what to do for the dates. Do I need a table that will store these four values? Can I create a temporary variable? Where do I specify the search criteria? Query? Function?
Thanks in advance!