Infiltrator64
Board Regular
- Joined
- Dec 19, 2004
- Messages
- 63
I have a query that selects records that are in a date range a user enters when prompted.
The field this query looks at is a combination date/time.
Example format: 7/14/2006 10:15:00 AM
The problem I’m having is if I answer just 7/14/2006 to the date range prompt it doesn’t return any records. If I answer 7/13/2006 to 7/14/2006 it will return all records for 7/13/2006 but none for 7/14/2006.
The select criteria I use to query the date/time field is as follows;
>=[start] And <=[end]
I simply want to select all records that have records equal to or greater than [start] and less than or equal to [end].
Can someone help me with the correct select criteria to use to perform this?
The field this query looks at is a combination date/time.
Example format: 7/14/2006 10:15:00 AM
The problem I’m having is if I answer just 7/14/2006 to the date range prompt it doesn’t return any records. If I answer 7/13/2006 to 7/14/2006 it will return all records for 7/13/2006 but none for 7/14/2006.
The select criteria I use to query the date/time field is as follows;
>=[start] And <=[end]
I simply want to select all records that have records equal to or greater than [start] and less than or equal to [end].
Can someone help me with the correct select criteria to use to perform this?