summing a field via a query

[Michael]

I created a query to extract certain fields to a report.
In the report it should sum up the amounts of like
fields. However, I'm having problems getting it to sum
up the amounts correctly.

The like fields are exactly alike except for the date
(the date was used to extract the correct fields in the
query). It seems only to sum up the like fields if I
leave the date out. How do I exclude the date from the
summing process but still use the date to extract the
fields?

Utlimately, I'm trying to make a report summary where it
adds up all the like fields regardless of the date field.

 

[John Vinson]

I created a query to extract certain fields to a report.
In the report it should sum up the amounts of like
fields. However, I'm having problems getting it to sum
up the amounts correctly.

The like fields are exactly alike except for the date
(the date was used to extract the correct fields in the
query). It seems only to sum up the like fields if I
leave the date out. How do I exclude the date from the
summing process but still use the date to extract the
fields?

Utlimately, I'm trying to make a report summary where it
adds up all the like fields regardless of the date field.

You're assuming that we know your table structure, the nature of your
query, and the nature of your report. We don't. Care to give us a bit
of help?

On a Report it's usually simplest to just base the Report on a query
returning the detail data and put controls in the Report footer with
control source

=Sum([fieldname])

rather than trying to do the sum *and* the details in a query.