Form with calculations like excel

  • Thread starter Thread starter sunilkeswani
  • Start date Start date
S

sunilkeswani

How do make a form display calculation based results on excel? Like for
example, on a scoresheet, on various percentage parameters, I want the
final score to be displayed on the form on the basis of the inputs...I
know how to do this on excel, but was wondering if I could do this on
Access form for display while the entries are made.

Regards
Sunil
 
add an unbound textbox control to your form. in the form's ControlSource
property, add an expression that performs the calculations you want. for
example:

= [ControlA] * [ControlB]

note that the resulting value will *not* be saved in the form's underlying
table, nor do you want it to be. anywhere you want the calculated value to
be displayed (in a query, a report, another form), just use the same
expression to recalculate it.

hth
 
thanks this works fine, but when I try to add 14 different check boxes,
it does nt work..any reason why? Is there another way?
 
not sure what you mean by "add...check boxes". a checkbox has a boolean
value, True Or False, the numeric value being 0 or -1. you're wanting to add
fourteen 0/-1 values? also, post the expression you're using in the unbound
textbox control, so we can review it.

hth
 
Back
Top