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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A Complicated Query Question 4
access query with 12 columns 2
Crosstab Query & Month Names 3
Dates360 formula in Excel for Access 2
How To create Dynamic Coloum names? 7
How to add multiples records from a querie 1
using a rolling date range to sum 1
Repeating records in Query 20

Back
Top