show/not show control

[eighthundred]

how can i control a field to show/not show at the query level?
let's say i have a query (from a table) like this

[regularPrice] [isOnSale] [onSalePrice]

where [isOnSale] is checkbox. if it's checked, [onSalePrice] will show [price]*0.9; if it's not checked, [onSalePrice] show nothing.

i've tried to put "[isOnSale]=Yes" in the Criteria, the query will filter out only those records that's on sale, which i don't want...

please help

 

[Smart]

in your query try this

where [isOnSale] is checkbox. if it's checked, [onSalePrice] will show [price]*0.9; if it's not checked, [onSalePrice] show nothing

Saleprice:iif([onSalePrice]= -1,[price]*0.9,0)

(if onsalprice is ticked multiply price by 0.9 else make it 0)

 

[eighthundred]

smart,

it REALLY help!!!!
thanks man.