Year to date report

H

hlsess

I am trying to find out how to combine 2 names. A couple are reporte
twice in a year to date report and they need to be combined to mak
yearly figures accurate. anyoneunderstand my question??
 
L

Larry Linson

hlsess said:
I am trying to find out how to combine 2 names. A couple are reported
twice in a year to date report and they need to be combined to make
yearly figures accurate. anyoneunderstand my question???
Click to expand...

No, I don't understand.

Do you have two records, each with a different identifier, whose data you
want to combine? If so, I can imagine a query that would sum the values,
another select query that excludes these particular records, and a UNION ALL
query to join those two queries, to be used as the RecordSource for the
report.

If this is not what you have, please clarify.

Larry Linson
Microsoft Access MVP
 
Top