query returning too many records

S

stephanie

I have a query based on 3 tables. It is very similar to
another query I have, also based on 3 tables. The first
one works fine. This second one comes back with about 500
more records than there should be.

Steph from CO
 
R

Rob Waibel

Looks like there could be a one to many relationship that
is causing duplication. Are the records all unique? If
not, I would start by determining what records are getting
duplicated.

Rob
 
V

Van T. Dinh

Post relevant details of your Tables, especially the link Fields and the SQL
String of your Query.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report Group Footer DLookUp 0
Grouping Names in Mail Merge 0
QBF & Query Malfunction 0
Check Box query help 2
query to show where no data in a stated column 0
Select query returning too many records 2
Querying 500 records 4

Top