How to change data?

G

Gary

Hi,

I want to make a query can change the data from "A" to "B"

"A"
Contact Country
AQ-00786 China
AQ-00786 Taiwan
AQ-00786 Japan
AQ-00786 USA

"B"
Contact Country
AQ-00786 China,Taiwan,Japan,USA

Hope someone can help!!

Gary
 
D

David Cleave

Hi Gary

Unfortunately there is no query function which will concatenate data in the
way you describe (i.e. add "China" & "Taiwan" and give "China,Taiwan" so you
can stop looking!! I have wished for something like this myself many times...

I'm afraid the only way to achieve something like this is though Visual
Basic code.

Cheers

David
 
G

Gary

Thank David

David Cleave said:
Hi Gary

Unfortunately there is no query function which will concatenate data in
the
way you describe (i.e. add "China" & "Taiwan" and give "China,Taiwan" so
you
can stop looking!! I have wished for something like this myself many
times...

I'm afraid the only way to achieve something like this is though Visual
Basic code.

Cheers

David
 
Top