On Tue, 7 Jun 2005 13:01:04 -0700, "dogpigfish"
wrote:
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
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]
|