Selecting Criteria in a Query

[tigrou]

Hi, I'm a complete novice to Access and wonder if anyone can help me with this one please? I have a column in a query that is the output from a barcode scanner called WhenScanned from a table tblScans. The data in the column is in the format of the date and time for example: 20/01/2006 21:30:00 I want to be able to interrogate the data in the query by selecting a range of a date(s) and times for example from 20/01/2006 05:30:00 to 20/01/2006 13:29:00, date and time range from 13:30:00 to 21:29:00, date and time range from 21:30:00 to next day 05:29:00. I can achieve this by typing the required range into the criteria row of the query column in design view e.g. >=#20/01/2006 13:30:00# And <=#20/01/2006 21:29:00# for each range but I want to make it more user friendly so that a user can select type in the appropriate date and select the time range from a drop down list or something without having to edit the query using syntax. Thanks in anticipation.

 

[AngelsGuardian]

is the data all in one ? ..meaning that you have the date and time in the same column ?
If that so..before you go on.. you should think of rethinking it and put a column with date and one with time ...you would make your life way easier ;O)

 

[tigrou]

Thanks for the reply, sadly the data is in one column only and I don't know any way of separating the date from the time.