Multiple records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

From two tables I run a query which gives me, for example:
RecNo Name Add1 Type
1 Joe A Plumber
1 Joe A Plumber
2 Fred B Electrician
3 Jim C Plasterer
3 Jim C Plasterer

The RecNo is common to both tables
The Name and Add1 come from Table1
The Type comes from Table2

I need to remove the repeated lines
Thanks!
 
Change the SQL from SELECT RecNo, ... to SELECT DISTINCT RecNo, ...

To do this through the GUI without having to deal directly with the SQL,
check the Properties of the query when it's open in Design mode. The 3rd
property should be "Unique Values": set it to Yes.
 
Back
Top