Need to add 5 fields to each column of a table
- From: Madmaxrtw@xxxxxxxxx
- Date: Tue, 29 Jan 2008 12:39:04 -0800 (PST)
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
.
- Follow-Ups:
- Re: Need to add 5 fields to each column of a table
- From: ClevelandSteve
- Re: Need to add 5 fields to each column of a table
- Prev by Date: Re: Date Fields
- Next by Date: varying pay rates
- Previous by thread: Re: Why He Left Me After...?
- Next by thread: Re: Need to add 5 fields to each column of a table
- Index(es):