linking

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

Guest

I have linked several excel tables to access - note all excel tables have the
same type of info./field names. How can I run a query pulling all into one
for reporting purposes
 
try using a Union query, along the lines of

SELECT Fieldname, FieldName, FieldName
FROM TableName
UNION SELECT Fieldname, Fieldname, Fieldname
FROM TableName
UNION SELECT Fieldname, Fieldname, Fieldname
FROM Tablename;

note the each SELECT statement must include the same number of fields.

hth
 
Back
Top