calculated fields in a report

[pigsy101]

i have a database which measures the level of toner cartridges we have
in stock.

A report shows the printer, cartridge, opening stock, ordered,
allocated, total in stock, reorder level and a calculated field to
give =[Total In Stock]-[reorderlevel].

This all works fine.

I want to display a check box that is true if the number calculated
field result is 1 or less and false if it is 2 or more. I want the
source of the check box to be the calculated field

The calculated field name is [balance] and the check box is [re-
order?]

I know this can be done with code but i can't work it out.

thanks in advance

 

[Baz]

Answered in microsoft.public.access.reports