can't perform query as shown in tutorial

[katomich]

Hello,
I am trying to follow this tutorial and can't figure out what I am doing wrong to get the following error message . I have been following this tutorial doing the Challenge section located at the bottom on the webpage.

Here is a link to \ the practice file. I am following the directions creating the query using the 2 specified tables, changing the direction of the join properties/relationship arrows, entering "27609" in the zip code field, and "Yes" in the paid field, but get the following error message (please see attachment) when I run the query.



When I do not add "Yes" in the paid field (as stated in the instructions), the search results come out correctly with 20 results. Do you know what I am doing wrong? thank you

[pbaldy]

If Paid is a Yes/No field, you don't want quotes around Yes. Alternatively, you can use -1, which is how Yes is stored.

[aytee111]

Quotes are used for text data types, I suspect that the Paid Field is not text, it is a Yes/No? In which case remove the quotes.

[katomich]

Thank John for your quick reply. You were exactly right!

[pbaldy]

If by John you mean me, you're welcome.

[katomich]

Thank you everyone for your replies and support.

[katomich]

Thank you Paul.