Form with calculations like excel

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
 
T

tina

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
 
S

sunilkeswani

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?
 
T

tina

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
 
Top