Selecting Data

message from Always Learning on 19 May 2004

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 replied to Always Learning on 19 May 2004

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" <NoMoreSpam@MyEmail> wrote in message
news:O8p4qwYPEHA.3140@TK2MSFTNGP11.phx.gbl...

Always Learning replied to Nikos Yannacopoulos on 19 May 2004

Thanks Nikos,

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

Best Regards,

Steve.

"Nikos Yannacopoulos" <nyannacoREMOVETHISBIT@in.gr> wrote in message
news:%23E3fgHZPEHA.556@tk2msftngp13.phx.gbl...

Archived message: Selecting Data (Microsoft Access Error Message)