Adding two days of data on one row

  • Thread starter Thread starter Nick Anderson
  • Start date Start date
N

Nick Anderson

Hi,

Here is the issue. I am using Access 2003. I am in a central time zone and I
run a report that is in Pacific time zone. When I export this data it shows
all of the data for yesterday and then goes into two hours today. For
example: The report that i run is from 2:00 am CST which would be 12:00 PST
on 1/28/2008 to 1:59 am CST which would be 11:59pm PST on 1/29/2008. When
this report is exported I am showing data essentially from 2:00 on 1/28 to
1:59 on 1/29. Since I have data for two days I need to get a total for three
colums. I then need to calculate a formula based on that information. I know
the formula but need help with how to add the two days worth of data into one
number.

Here is an example

Date Column1 Cplumn2 Column3 Total
1/28/2008 1234 5678 9012 (this would
be a formula)
1/29/2008 23 67 90 (this
would be a formula)
I want to add these three columns together to get one
number

Does anyone have any suggesstions.

Thanks for your help.
 
I am guessing that you are asking the query to sum/group on a field
other than the field you are using for selection criteria.

Try using the same field.

Ron
 
Back
Top