calculated fields on a report

  • Thread starter Thread starter pigsy101
  • Start date Start date
P

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
 
You don't need code. Just set the check box's control source to this:

=([Total In Stock]-[reorderlevel]<2)
 
Back
Top