Repeating Records In Queries

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.
 
J

Jeff Boyce

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.
 
Top