IF Statement Lookup

[Guest]

Hi Guys,

I'm hoping someone can help me, I'm lookin for an expression which will look
up a series of data values and provide an output based on those values,
please see the sample below.

I have two fields of data, "Orders" and "Part Number"

orders p/n
1 XXXXX
1 XXXXX
2 YYYYYY
2 YYYYYY
3 XXXXX
3 XXXXX
3 YYYYYY
3 YYYYYY

What I would like to do is groupby the Order field, and for each order show
the value "X" if "XXXXX" is found within the p/n field and "YYYYY" is not, i
would also like to show the value "Y" if "YYYYYY" is found within the p/n
field and "XXXXX" is not, finally i would like to show the value "X&Y" if
"XXXXX" and "YYYYY" are found within the p/n fields?

Any suggestions on this would be must appriciated.

Mo..

 

[[MVP] S.Clark]

Duane Hookum's concatenate function can help.
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
Click on:
Generic Function To Concatenate Child Records (46 KB) Access 2000

This will concatenate entire part numbers, but you could add some codeto
translate it to just the single char.