Selecting Data

[Always Learning]

Hi Guys,

This is my first posting here.

I have a couple of problems if someone could help me please.

1. How do I select all records from Table1 that is not in Table2. I need to
get all the fields but only records that do not have a matching Surname,
AddressLine1 & PostCode in Table2.

2. How do I select Unique records out of Table1 Based on Surname,
AddressLine1 & PostCode. I need to return all the fields.

Thank you for any help you can offer on this.

Best Regards,

Steve.

 

[Nikos Yannacopoulos]

Steve,

1. Access has a built-in wizard for this. Select container Queries" in the
db window, click on New, then select Find Unmatched and follow the wizard
instructions.

2. make a new query in design view, select your table and get the desired
output fields down to the grid. Go to menu item View > Totals, and select
total function Group By for fields Surname, AddressLine1 & PostCode. As for
the rst of thefields that you want returned, you should select First, Last,
Min or Max, depending on what you want, so it only returns one record for
each unque combination of Surname, AddressLine1 & PostCode.

HTH,
Nikos

 

[Always Learning]

Thanks Nikos,

I appreciate your time to respond to this and my other post.

Best Regards,

Steve.