How do i Sum records between 2 date & time's ( Access2002)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hope somebody can help, i have a database that i link to retreive entry results,( the original database can not be altered ).
I'm want to sum up the entered records between friday @ 3pm to the following friday @ 3pm. The original database unfortunatly has the data & time in seperate fields. I have added criteria in my query to ask for between two dates but i have not managed to knock off the unrequired records ie before 3pm and after on the start and end date.
 
I would try converting the original data into Access date fields using
the cDate() function. If you pass this a string that Access
recognizes, it will translate it into a date (eg: ?CDate("Oct 27,
2003") + CDate("15:00:00") yields "10/27/03 3:00:00 PM" in the debug
window).

Are you only interested in one weeks data in your query, or do you
want this presented with multiple "weeks"? If you want multiple
weeks, how do you want to represent that week in your output?

--
HTH

Dale Fye


Hope somebody can help, i have a database that i link to retreive
entry results,( the original database can not be altered ).
I'm want to sum up the entered records between friday @ 3pm to the
following friday @ 3pm. The original database unfortunatly has the
data & time in seperate fields. I have added criteria in my query to
ask for between two dates but i have not managed to knock off the
unrequired records ie before 3pm and after on the start and end date.
 
Back
Top