joining two fields together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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.
 
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...
 
Back
Top