iff Statement Between 2 queries.

[smc678]

Is it possible or what is the best way if i want to compare 2 queries on specific collums. If they match it would return Y if not a N. So if qryIBLOS [SHPMT_NBR] matches qryFluidASNs [UNVERF_FLUID] a Y would show if not a N would return. Any Ideas out there?

[June7]

Are these the common ID fields that link the two queries?

[smc678]

I can make them that way I need to view all items in qryIBLOS though qryFluidASNs has just a few items

[June7]

Options:
1. create another query that joins these two, join type "Show all records from qryIBLOS...", create a field with expression -
IsMatch: IIf([SHPMT_NBR]=[UNVERF_FLUID],"Y","N")

2. use DLookup() in expression in qryIBLOS, assuming SHPMT_NBR is text value -
IsMatch: IIf(IsNull(DLookup("UNVERF_FLUID", "qryFluidASNs","SHPMT_NBR='" & [SHPMT_NBR] & "'")), "N", "Y")

[smc678]

You are good my Friend!!!