Union Query question

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I'd like to run a Union like query but the two data sets
have a different number of fields, and Access gives me an
error message that the two data sets are different sizes.

Is there a way around this error?

Essentially, I'm trying to add a new field on to an
existing table, but the regular select query may exclude
some of the new data because the "join keys" on the
existing table are a subset of the secondary table (with
the new field).
 
The only way around it is to create a null field in one of
the select statments:


Select FirstName,LastName,MiddleInitial from tblEmployees
UNION
Select FirstName,LastName,Null as MiddleInitial from
tblCustomers


Chris Nebinger
 
Back
Top