ACC2: Date Range Parameter Query Returns No Records

MORE INFORMATION

Steps to Reproduce Problem

1. Create a table with the following structure:
   

         Table: TestDates
         -------------------------------
         Field Name: ID
            Data Type : Counter
            Indexed: No
         Field Name: Date
            Data Type : Date/Time
            Indexed: Yes (Duplicates OK)
   						

2. Save the table as TestDates. When Microsoft Access prompts you whether to create a primary key, choose the No button.
3. View the TestDates table in Datasheet view and type the following six records in the Date field:
   

         12/23/94
         12/25/94
         12/30/94
         1/1/95
         1/1/92
         12/31/93
   						

4. Create the following query based on the TestDates table:
   

         Query: Test1
         -----------------------------------------------------------------
         Field: ID
             Show: Yes
         Field: Date
             Show: Yes
             Criteria: Between [Enter a start date] And [Enter an end date]
   						

5. Run the Test1 query and, when prompted, type the following dates:
   

         [Enter a start date]: 12/23/94
         [Enter an end date]: 1/1/95
   						

   
   Note that you receive zero records rather than the four records you expect.