[Deep_Si]

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

 

[Deep_Si]

Re: access2003 query - replacable parameter based on a logic field

I added a new field in the query like shown

Field: MyParam: IIf([DepositPaid]=-1, "Yes","No")
Show: True
Criteria: Like [Enter Yes, No or *]
ran and checked it then hid it and it works fine now.