joining two fields together

C

carrie pedersen

I'm trying to combine a field together. I have three field names

Name Class Manufacturer
NS PF latex Cardinal
NS PF latex Medline
NS powder Cardinal
NS powder Medline


I want to join the manufacturer field in the class field so it would look
like this:

Name Class
NS PF latex
Medline
Cardinal
NS powder
Medline
Cardinal

Is there any way to do this?

Thanks for any help!
 
D

Duane Hookom

Please try again since we can't tell which values are in which field. It
looks like you are taking 4 records and attempting to make 6 records.
 
V

Vincent Johns

Duane said:
Please try again since we can't tell which values are in which field. It
looks like you are taking 4 records and attempting to make 6 records.
Click to expand...


I agree, it wasn't obvious, but reading between the lines I inferred
that the Table looks something like this:

[Product]

Name Class Manufacturer
----- ------ ------------
NS PF latex Cardinal
NS PF latex Medline
NS powder Cardinal
NS powder Medline

Here, I assumed that what is desired is 2 fields, looking something like
this:

Name ClassManuf
------ ---------------
NS powder Cardinal
NS powder Medline
NS PF latex Cardinal
NS PF latex Medline


and that can be done with the following Query; you will likely choose to
change the sort order or the punctuation, etc.:

SELECT Product.Name,
[Product]![Class] & " " & [Product]![Manufacturer]
AS ClassManuf
FROM Product
ORDER BY Product.Name, Product.Manufacturer;


-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
D

Duane Hookom

Good WAG...

--
Duane Hookom
MS Access MVP
--

Vincent Johns said:
Duane said:
Please try again since we can't tell which values are in which field. It
looks like you are taking 4 records and attempting to make 6 records.
Click to expand...


I agree, it wasn't obvious, but reading between the lines I inferred that
the Table looks something like this:

[Product]

Name Class Manufacturer
----- ------ ------------
NS PF latex Cardinal
NS PF latex Medline
NS powder Cardinal
NS powder Medline

Here, I assumed that what is desired is 2 fields, looking something like
this:

Name ClassManuf
------ ---------------
NS powder Cardinal
NS powder Medline
NS PF latex Cardinal
NS PF latex Medline


and that can be done with the following Query; you will likely choose to
change the sort order or the punctuation, etc.:

SELECT Product.Name,
[Product]![Class] & " " & [Product]![Manufacturer]
AS ClassManuf
FROM Product
ORDER BY Product.Name, Product.Manufacturer;


-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
Click to expand...
 
Top