44 records but my report shows 3,225...?!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just built a report and it access only 44 records. However, it opens and
displays 3,225. This is very strange. I cycled through the first 44 records
and then to my surprise the report came back to the first record again. The
report is cycling through all 44 records.

Anyone know what causes this?

Thanks!
 
John,
Without more details, it's pretty hard to say for sure, but...
If you have more than one table in the query behind this report, then you
probably have an improper relationship established between those tables.
This appears to be a Cartesian ralationship rather than a One to One or
One to Many.
If I have a table with 10 records , and link it to another "unrelated"
table with 20 records, the query will deliver 20*10 or 200 records.
Sounds like you're improperly linking your 44 records to a table with
approx. 73 records.
hth
Al Camp
 
Thanks, Al! Actually, I have 43 records that were being affected by an
unrelated table of 75 records. I mistakenly added this table to the report's
query and never thought to loo there!

THANKS!
 
Back
Top