How to change data?

[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

 

[Guest]

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

 

[Gary]

Thank David

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

 

[John Spencer]

There is a generic function by Duane Hookom
at:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane