Query showing multiple records

  • Thread starter Thread starter millie.patel
  • Start date Start date
M

millie.patel

I need to create a query based off another query and a table.

The first query: has fields A, B, C, D, E, F, G, H, etc
and returns 228 rows

The table (table 1) I am trying to use has A, B, C, D, anotherfield

I want the final query to display A, B, C, D, E, F, G, H, etc and
anotherfield

When I try running the query and setting where A=A and B=B and C=C and
D=D, I get over 1,000 rows because it is creating a new record for
every item in Table 1.

How do I fix this?

Thanks,

Millie
 
Link the Query filed to the table by just dropping the field from query to
the table where they match.
 
Back
Top