March 17th, 2004, 07:57 AM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL Problem
I need to get an sql statement which will get the number of cases between two dates specified by the user and on a certain hour
This is what i have so far
SELECT Count(Accepts.Queue) AS CountOfQueue
FROM Accepts
WHERE ((Accepts.Queue)='31000 - France') And (Accepts.TimeOfAccept) Between (#1/12/2002#) And (#5/27/2002#);
I thought it might be possible to use ON FORMAT hh so that it will only count the cases for a particular hour but i could not get it to work does anyone have any ideas
THanking you in advance
John
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
