Repeating Records In Queries

  • Thread starter Thread starter Asa Kaplan
  • Start date Start date
A

Asa Kaplan

I've set up a query which should show twelve (12) records.
However, it shows 96 records repeating the twelve (12)
records six times.
 
Asa

This can happen if you neglect to JOIN two tables in a query -- Access
thinks you want to "multiply" the rows of each table together.

If you provide the SQL statement, the 'group's readers may be able to offer
other suggestions.
 
Back
Top