Parameter Query using various search methods

[benwo]

Hi

I have a table in sql holding telephone data. the starttime column and endtime column are both in "10/05/2006 12:55:56" format.

I want to run a parameter query that lets me search by agent name and then by date. The agent name is no problem but when running parameter query by date it brings back no data. I think this is because the time is also in the same field as the date. Ideally I would like to be able to run the query between certain dates, e.g. find data for agent1 between 2 different dates.

Any help would be more than appreciated!!

Thanks

Ben

 

[Jon K]

In query Design View, put the criteria for the date/time field in a separate column in the query grid like this:-
--------------------------
Field: DateValue([DateTimeFieldName])

Show: uncheck

Criteria: Between [Enter start date] And [Enter end date]
--------------------------
.

 

[benwo]

perfect, thank you!!!