Make Table Query-Access 2007

[NeedExcelHelp07]

In Access 2007 I am trying to create a Make Table Query.
I have three tables that I want to extract data from, they have a
relationship based on the Logon. How can I design the query so that I can
choose the fields I want from the three tables, but I want to eliminate the
duplicates if 3 of the chosen fields are equal. Help!

Thanks

 

[KARL DEWEY]

I would start with a union query and not put the 'ALL' in the select statement.
Then edit the SQL and add the
INSERT INTO [AAA] ([xxx], [yyy], [zzz]) where the xxx, yyy, and zzz
are the field names for new table AAA.

 

[NeedExcelHelp07]

I am not familar with how to make a union query. How would I write the query
if the fields that match are Logon, and I want to display all of the fields,
but no duplicates when Logon and Privileges are the same?

Thanks

I would start with a union query and not put the 'ALL' in the select statement.
Then edit the SQL and add the
INSERT INTO [AAA] ([xxx], [yyy], [zzz]) where the xxx, yyy, and zzz
are the field names for new table AAA.
--
KARL DEWEY
Build a little - Test a little

In Access 2007 I am trying to create a Make Table Query.
I have three tables that I want to extract data from, they have a
relationship based on the Logon. How can I design the query so that I can
choose the fields I want from the three tables, but I want to eliminate the
duplicates if 3 of the chosen fields are equal. Help!

Thanks