Concatenate Data from same fields from different records

  • Thread starter Thread starter BobbyOH
  • Start date Start date
B

BobbyOH

Can I concatenate or update some way, data from the same fields from two
different records?

I want to combine items donated for an auction. For example:

Donor1 gave Item ["a certificate for ski lessons"]
Donor2 gave Item ["a pair of skis"]

I'd like to be able to add the Items from Donor1 and Donor2 so the auction
Item will be "a pair of skis and ski lessons".

Can this be done using a query?

Thanks...
 
Can I concatenate or update some way, data from the same fields from two
different records?

I want to combine items donated for an auction. For example:

Donor1 gave Item ["a certificate for ski lessons"]
Donor2 gave Item ["a pair of skis"]

I'd like to be able to add the Items from Donor1 and Donor2 so the auction
Item will be "a pair of skis and ski lessons".

Can this be done using a query?
Click to expand...

You're giving Access credit for a human understanding of the English
language which it lacks. At the best you might be able to generate

"a certificate for ski lessons and a pair of skis"

with the actual content of the fields; and if you had four or five
items, you'ld get a very long unwieldy sentence.

To do this much, you can consider using the VBA code at

http://www.mvps.org/access/modules/mdl0004.htm

It'll be very much more difficult in a query unless you always have
two and exactly two donors.

John W. Vinson[MVP]
 
Wow, thanks for your help. I'll try to use that code.


John Vinson said:
Can I concatenate or update some way, data from the same fields from two
different records?

I want to combine items donated for an auction. For example:

Donor1 gave Item ["a certificate for ski lessons"]
Donor2 gave Item ["a pair of skis"]

I'd like to be able to add the Items from Donor1 and Donor2 so the auction
Item will be "a pair of skis and ski lessons".

Can this be done using a query?
Click to expand...

You're giving Access credit for a human understanding of the English
language which it lacks. At the best you might be able to generate

"a certificate for ski lessons and a pair of skis"

with the actual content of the fields; and if you had four or five
items, you'ld get a very long unwieldy sentence.

To do this much, you can consider using the VBA code at

http://www.mvps.org/access/modules/mdl0004.htm

It'll be very much more difficult in a query unless you always have
two and exactly two donors.

John W. Vinson[MVP]
Click to expand...
 
Back
Top