[SOLVED] access2003 query - replacable parameter based on a logic field

Hello Everyone,

I have a simple replacable parameter query in access 2003 which includes a parameter based on a logic field.

when I run the query I want the user to be able to enter Yes or No or * instead of -1 or 0 or * (which are their options at the moment)

entering Yes or No returns no records
entering 0 or -1 or * returns records as expected.

Changing the format of the field (in the table or query) to yes/no seems to have no effect on this parameter input. I prefer it to show yes/no than 0 -1 by the way which changing the format does fine

the criterea is set to

Like [Deposit Paid Yes, No or *]

Thanks for any help you can give me with this.

Simon