Hi All,
I could really use some direction on this please!
I'm not sure how to go about it.
I'm thinking it will have to involve multiple queries, not sure at all what i need to do.
I have a table with 5 fields.
ResinCode
R1
R2
R3
R4
There are some ResinCodes that are only comprised of R1 in which case R1 is the equivalent of that ResinCode.
Other ResinCodes however are blends of different ResinCodes (Some use R1 and R2, a few use R1, R2, and R3, etc.)
I want to create a parameter query that will prompt me to enter a ResinCode and after I type a ResinCode into the parameter question,
the query results will return any ResinCodes records that contain that particular ResinCode in any of the other 4 fields (R1, R2, R3, R4).
an example of the query im looking for would be like this:
[ENTER RESIN CODE]
if I enter R001,
it might return for example:
R001
R008
R022
In this case being that R001, R008, and R022 all contain R001 in either field R1, R2, R3, or R4
Thanks for any direction, I appreciate it.
BJF
I could really use some direction on this please!
I'm not sure how to go about it.
I'm thinking it will have to involve multiple queries, not sure at all what i need to do.
I have a table with 5 fields.
ResinCode
R1
R2
R3
R4
There are some ResinCodes that are only comprised of R1 in which case R1 is the equivalent of that ResinCode.
Other ResinCodes however are blends of different ResinCodes (Some use R1 and R2, a few use R1, R2, and R3, etc.)
I want to create a parameter query that will prompt me to enter a ResinCode and after I type a ResinCode into the parameter question,
the query results will return any ResinCodes records that contain that particular ResinCode in any of the other 4 fields (R1, R2, R3, R4).
an example of the query im looking for would be like this:
[ENTER RESIN CODE]
if I enter R001,
it might return for example:
R001
R008
R022
In this case being that R001, R008, and R022 all contain R001 in either field R1, R2, R3, or R4
Thanks for any direction, I appreciate it.
BJF