calculated fields on a report

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

You don't need code. Just set the check box's control source to this:

=([Total In Stock]-[reorderlevel]2)

"pigsy101" wrote in message
oups.com...
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