By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 3,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Need to add 5 fields to each column of a table

P: n/a
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

Jan 29 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
SELECT [tblXNumber]![Item] & " " & [tblComName]![ComName] AS NewItem
FROM tblXNumber, tblComName;
Jan 29 '08 #2

P: n/a
On Jan 29, 4:19*pm, ClevelandSteve <syahn...@hotmail.comwrote:
SELECT [tblXNumber]![Item] & " " & [tblComName]![ComName] AS NewItem
FROM tblXNumber, tblComName;
Thank you for spurring my memory--I feel rather stupid!

Jan 29 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.