Look up query

[kiranair]

I have a small problem in my query in access 2010
1) I have to look up both T/S and T/S1 and list down all as T/S I have done it.
2)based on T/S I have to decide whether its C or N i.e eg if bagging in T/S is n maximum no of times N then N
2) same for T/s1

right now in my example their is no C but if its present then it will be same for all the T/S wrt name of T/S eg if painting is Cthen it ll be c in T/S and T/S1



Now I have to list decide whether its C or N in

[CJ_London]

your image quality is poor and regret I cannot read it.

Having / in field or table names is a bad idea, but if you have to use them put the field name in square brackets.

And do not understand your explanation or what you are asking - what is C? what is N?

[kiranair]

oh never mind
I wanted to make a list of T/S and their respective C or N looking at 1st table which I solved it few minutes back

thank you for your reply.