A "Yes" or "No" Field in place of a yes/no check box in a qu 1

[robojeff]

I have a query which pulls a part number from one table and
pulls a Yes/No field from another table but in my query I would like to set the criteria
to place an actual "Yes" or "No" in a serialized field instead of the check box...

My query is as follows:

SELECT AllParts_tbl.Item, Serialized_tbl.yesno
FROM AllParts_tbl LEFT JOIN Serialized_tbl ON AllParts_tbl.Item = Serialized_tbl.PartNumber;

How can I set this up to place a yes or No in a Serialized (text type) field in my Query?

Thanks

 

[PHV]

Perhaps this ?

SELECT A.Item, IIf(S.yesno, "Yes", "No") AS Serialized
FROM AllParts_tbl AS A LEFT JOIN Serialized_tbl AS S ON A.Item = S.PartNumber

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[robojeff]

Yes this works great!

Thank you!