HOW DO I?

[Guest]

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!

 

[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>

 

[[MVP] S.Clark]

=Budget - (Qauntity*Price)

 

[Guest]

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

thanks so much!