Date group

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

Guest

I used a crosstable query to combine information. I need to know how to
combine all date groups of the same date. I may have two or three fields of
5/05/05, however I want one set of information. Here is an example...
I want this:

05/05/05 3.00
05/05/05 2.45
05/06/05 1.00

to become this:

05/05/05 5.45
05/06/05 1.00
 
I used a crosstable query to combine information. I need to know how to
combine all date groups of the same date. I may have two or three fields of
5/05/05, however I want one set of information. Here is an example...
I want this:

05/05/05 3.00
05/05/05 2.45
05/06/05 1.00

to become this:

05/05/05 5.45
05/06/05 1.00
Click to expand...

Create a Query based on your table. Change it to a Totals query by
clicking the Greek Sigma icon (looks like a sideways M); leave the
default Group By on the date field, and change it to Sum on the number
field.

If the date/time field contains (concealed) time portions, you may
need to group on a calculated field:

DateOnly: DateValue([datefield])


John W. Vinson[MVP]
 
Back
Top