Yes / No Field on Query

Hi Lisa,

Thank you for your post;

In a Form or Report consider the following, if for example you have the following fields: Taxable, Item Cost, Item quantity where Taxable is your yes/no field.

In the Detail section of the form I would create a textbox with the formula: IIf([Taxable]=-1,([Item_Cost]*[Quantity])*0,0) (note the change to -1 from 1) and call it say TaxableAmount.

-1 is a yes in an Access Database and 0 is a no.

Try that it should work, if not please come back, regards Pete

Hi Lisa

Thank you for your question

You simply need to enter yes into the criteria field of your query designer, under the relevant column.

Alternatively, you can enter -1 or 0.

Regards


Stephen