B
bobw
I have a report that uses a query. The query selects records based on the
"date" field. All records have the following fields: Name, ID, Date,
Amount, Record Type.
The report groups the two record types for each Name and totals on each
record type. I want to sum all of the record type = C and record type = P in
the report footer. I have tested the report when the query reads all of the
records with a Dsum statement and the totals for record type = C and record
type = P and the correct totals are returned. However, when I insert the
record selection criteria in the underlying query for the report, an 'error'
is returned.
Can you tell me what I am doing wrong ?
Thanks.
"date" field. All records have the following fields: Name, ID, Date,
Amount, Record Type.
The report groups the two record types for each Name and totals on each
record type. I want to sum all of the record type = C and record type = P in
the report footer. I have tested the report when the query reads all of the
records with a Dsum statement and the totals for record type = C and record
type = P and the correct totals are returned. However, when I insert the
record selection criteria in the underlying query for the report, an 'error'
is returned.
Can you tell me what I am doing wrong ?
Thanks.