Need to add 5 fields to each column of a table

What I have is one table (tblXNumber) with a bunch of data numbers in
it. For example:

123456
123456.05.02.01
123456.05.02.01.01
etc.

Then I have a seperate table with Item names in it (tblComName).
There are only 5 fields in this table they are:

AllOther
Inventory
PersonnelCosts
ServicePools
Travel

What I need to do is have each of the five fields from tblComName add
to each of the number fields in tblXNumber

Result Set:

123456 AllOther
Inventory
etc.
123456.05.02 AllOther
(I think you get the idea)

I have tried a union query and it adds the fields to the bottom of the
table. How can I accomplish the result set?

Thank you in advance

Me

Re: Need to add 5 fields to each column of a table

SELECT [tblXNumber]![Item] & " " & [tblComName]![ComName] AS NewItem
FROM tblXNumber, tblComName;

Re: Need to add 5 fields to each column of a table

On Jan 29, 4:19=A0pm, ClevelandSteve wrote:
> SELECT [tblXNumber]![Item] & " " & [tblComName]![ComName] AS NewItem
> FROM tblXNumber, tblComName;

Thank you for spurring my memory--I feel rather stupid!