Merging Fields in a Query

[Guest]

First off, let me say that I am pretty new at Access, but am learning as fast
as I can. To give you a little bit of understanding what I'm trying to do,
let me explain my situation a little bit. I am in the aircraft maintenance
business. We have Aircraft Component and Subcomponents that must be replaced
at certain hour use intervals. I am trying to create reports to give to
other maintenance assets to show them when components and subcomponents are
nearing replacement time. I have a Components table with fields such as
Component and Component Serial #. I also have a Subcomponents table that
have Subcomponent and Subcomponent Serial # fields. The subcomponents, I.E.
Turbine Wheels, are linked to the components, I.E. Engines, but have a lot of
the same data such as replacement due times. My question is can I make a
query that has fields labeled Comp/Subcomp and CompSN/SubcompSN and get the
Components and Subcomponents to show in the same Column but not in the same
field. I have tried using the Expression Builder with the following
expression Comp:[CompTable]![Component] & [SubcompTable]![Subcomponent] but
it will just list the two items together like EngineTurbine Wheels instead of
Engine in one row and Turbine Wheels in the same column in the next row down?
Any help will be greatly appreciated.

 

[Michael Hopwood]

It sounds like you need a UNION query, have a look in help for the
use/syntax.