February 27th, 2008, 04:48 PM
|
|
Registered User
|
|
Join Date: Feb 2008
Posts: 4
Time spent in forums: 39 m 40 sec
Reputation Power: 0
|
|
|
Qry by modifed day
Background: qry values sumed by day for a month returning each day.
Problem: Use production date instead of calendar date
Production Date starts at 6am and ends the following day at 5:59am
So 1/1/2008 is actually 1/1/2008 06:00 thru 1/2/2008 5:59
here is working qry for just one day.
Quote: SELECT Sum(tblDeviceData.Value) AS 'Gallons'
FROM tblDeviceData
WHERE (tblDeviceData.TimeStamp>'1/1/2008 06:00' And tblDeviceData.TimeStamp<'1/2/2008 06:00') |
how do i return this value along with the rest of the days in the month and the day for it?
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
