Help...Query Results Posted on a Form

[thenderson]

I have created a form w/ almost all the fields from one table. I have three
particular fields that the users will input data, costs, into. I want the
fourth field to populate w/ the results of those three and then store itself
w/ the info the user input into the form.

I have created a query which will calculate that cost. I have attempted to
add it to the form with a combo/list box and added a button to run the query
for the user. I get the results but it's all the results of each record I
create versus just one.

I appreciate any help or insights..

Thank you

 

[ruralguy via AccessMonster.com]

Start by basing your form on a query and add a field to the query that will
do the calculations for you.