Make Table Query - too many rows in return

[Itzkie]

I am using a "make table query". The table I am starting with has 187 rows.
The return query gives me 163640 rows (each row many, many times).

How do I fix that?

Thanks,

Melissa

 

[Jeff Boyce]

Melissa

We aren't there. We can't see your data. We can't see your query. The
question you asked is a little like saying "my car makes a funny noise ...
how do I fix that?"

First, try posting the SQL statement you are using...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson/MVP]

I am using a "make table query". The table I am starting with has 187 rows.
The return query gives me 163640 rows (each row many, many times).

How do I fix that?

By correcting the error in the query. At a guess, the query has more
than one table included (or the same table multiple times) with no
JOIN line, or incorrect JOIN lines, so that each record in one table
is paired with all of the records in the other table or tables.

Please open the query in SQL view and post the SQL text here.