Year to date report

  • Thread starter Thread starter hlsess
  • Start date Start date
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??
 
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
 
Thanks so much but I figured it out. They were duplicate record
showing up on ayear to date report but not in big report and th
duplicates were in the query. Thank
 
Back
Top