How to lookup a record and return 0 if not found.

[Spoilz]

Hi,

I am an access beginner but trying to do something that should be pretty simple.

I have a query called "customer" and a query called "promo" which contains promo codes. Not every customer has a promo code and some customers have multiple codes.

I want to create a field in the "customer" query that returns "yes" or "no" if that customer has any promo code.

I have been searching online all day and tried many different things but getting no closer. The best I can get is a field that returns "#error" if there are no records and "1" if there is a record.

Note - I am not so good on SQL so any help using access functions would be appreciated.

thanks,

[RuralGuy]

Are the "promo" codes in the same tables as the customers?

[Spoilz]

No. Actually both are in their own sub queries but the original data are in two different tables.

I have no problem moving across tables to get total orders when I am playing with numbers but when I try to do a simple lookup, I'm lost.

[RuralGuy]

Here's a link on how to do the Domain Functions. All of the arguments are STRINGS!
http://access.mvps.org/access/general/gen0018.htm
Post back here if it still evades you.