Make Table Query-Access 2007

  • Thread starter Thread starter NeedExcelHelp07
  • Start date Start date
N

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
 
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.
 
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

KARL DEWEY said:
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


NeedExcelHelp07 said:
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
Click to expand...
Click to expand...
 
Back
Top