Date and Time Query in SQL

[benwo]

Hi

I want to be able to run a query within access that lets me chose "agent" and a specific date or a range of dates.


I have a table with
"starttime", "endtime", "agent", "phonenumb" and a datediff calculation that calculates the diff between "starttime" and "endtime"
the "starttime" and "endtime" columns are in "10/05/2006 12:57:55" format, i.e. the column holds both the date and time

The data is stored in an sql DB and is accessed by an odbc link using Access 2003

I want to be able to run a query within access that lets me chose "agent" and a specific date or a range of dates.

Any help would be greatly appreciated

Thanks

Ben

 

[pdx_man]

What exactly are you having trouble doing?

3 postings of the same question ... tsk tsk tsk ...