basic question: calculating input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is very basic. I just need to know where to look...what terms to use
when I search the help files. An article would be great...or a tutorial.

How do I take the numbers entered by my users and add them and show the
result in a field on the form?

I know I probably have the form run a query after the user enters numbers
into the fields then hits a button. How can I learn about this?

Thanks much.
 
Just add an unbound text box to your form. Click in that box and enter your
formula starting with "=". For example...


=[SomeFieldName1] + [SomeFieldName2] /[SomeFieldName3]


etc.


Rick B
 
PaulFort said:
This is very basic. I just need to know where to look...what terms to use
when I search the help files. An article would be great...or a tutorial.

How do I take the numbers entered by my users and add them and show the
result in a field on the form?

I know I probably have the form run a query after the user enters numbers
into the fields then hits a button. How can I learn about this?

Thanks much.
Click to expand...
A quick google for "Access tutorial" brought up 16,800,000 hits.
This one looked pretty good.

http://www.fgcu.edu/support/office2000/access/\

gls858
 
Try these books:

Using Microsoft AccessXXX, Roger Jennings, Que Corp
Mastering AccessXXX Development, Allison Balter, SAMS
Beginning AccessXXX VBA, Smith and Sussman, WROX
 
But that just adds (and divides) the numbers already in SomeFieldName fields
when the form opens, doesn't it?

How do I allow the user to enter numbers in the first two fields then see
the sum in the third field, for example. Kind of like a little calculator.
 
my bad....just have to click in the total field and it updates with the
sum...Thanks Rick

PaulFort said:
But that just adds (and divides) the numbers already in SomeFieldName fields
when the form opens, doesn't it?

How do I allow the user to enter numbers in the first two fields then see
the sum in the third field, for example. Kind of like a little calculator.


Rick B said:
Just add an unbound text box to your form. Click in that box and enter your
formula starting with "=". For example...


=[SomeFieldName1] + [SomeFieldName2] /[SomeFieldName3]


etc.


Rick B
Click to expand...
Click to expand...
 
Back
Top