combining two fields in a query

[LELOA]

Hi
I have a query with multiple tables what I required is the following

Table 1 has a field label Scrubbed Part Number
Table 2 Has a field label Vendor Part number

what I need is if table 1's field is blank then insert table 2 field, if table 2's field is also blank then leave the field blank.

I hope this is sort of clear.

 

[randy700]

If I understand your question, try putting this field in your query....


PN:iif(isnull(ScrubbedPartNumber),iif(isnull(VendorPartNumber),"",VendorPartNumber,ScrubbedPartNumber))