Data Errors from Query to Report

JewliaB

Registered User.
Local time
Today, 03:00
Joined
Sep 11, 2008
Messages
27
I have a report that sums up the hours my volunteers have volunteered (per person) and gives me this, their ID No. and a couple other things (name, etc.). Everything looks great in the query I have, but the moment I try to create a report, all of the numbers go weird. The autonumbers don't fit and have things like +02 and duplicates, the sum hours has -2 for someone who has 313 hours volunteered. Everything just goes crazy. However, if I look in the query, everything is fine. Does anyone know what would cause the numbers to change between the query and the report if there are no calculations in the report?
 
The column widths are too narrow on the report.
 
Wow....umm..I feel very silly. I expanded the columns and that fixed the problem. Thank you very much pat.
 

Users who are viewing this thread

Back
Top Bottom