Eliminate the number of rows returned per each...

[Bee]

Hi,

I have made a query from different tables; however, my query is returning about 5 rows for each person because some fields in the query return more than 1 row.

Is there anyway to fix this problem?

Thank you,
B

 

[gemma-the-husky]

if you only want one record, change the query properties to unique values. You might find the query becomes non-updateable though.

 

[GaryPanic]

I run into this as well - try this in your qry between tables see if you have two field names the same or two values and link the tables twice

so table 1
id
client name (link line)
post code (another link line)

table 2
id
clientName (line line)
Pcode (another link line)

by linking on 2 lines this should elimate your multiples
failing this try Emmas approach

 

[Bee]

if you only want one record, change the query properties to unique values. You might find the query becomes non-updateable though.

No, my query is not returning duplicate rows unecessearily.
For each line in the query, it returns many different rows. I was thinking if there is a way instead of having the extra information dispalyed in a new raw, I want it displayed under a new heading.