Joining fields into one field dependent on value of another field

[c8tz]

Hi,

Below is a sample of data of a query which I need assistance in -

Group Fertiliser ApplicationRate
1 TSP 3
2 EFB 230
3 Kies. 3
4 EFB 230
4 Kies. 3
5 TSP 3
5 Kies. 3
7 EFB 230
7 TSP 3
7 Kies. 3

From this, I would like to create a field such that it shows eg.

Group FertiliserDescription
1 TSP (3)
2 EFB (230)
3 Kies. (3)
4 EFB (230), Kies(3)
7 EFB(230),TSP(3),Kies(3)

I am able to put Fertiliser and ApplicationRate together ie.
Fertiliser& "(" &ApplicationRate& ")"
My problem being how to add a statement saying that for group put
Fert&Rate together as show above.


thanks ever so much for your help.

 

[Guest]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.