HOW DO I?

S

sbshelp

hey guys - i have a form that needs to display a value in a text box. the
value is - budget - qauntity*price

how do i get that value in the text box?

thanks!
 
J

Jeff Boyce

If the query (or table) on which the form is based has fields named
[budget], [quantity], and [price], you could create a new (unbound) textbox,
and in that textbox's Control Source, put:

= [budget] - [quantity]*[price]

Another way to do this would be to do the calculation in the query on which
you base the form.

Regards

Jeff Boyce
<Office/Access MVP>
 
S

sbshelp

thanks guys! it worked! i just used the sum part in query instead of group
by.

thanks so much!
 
Top