basic question: calculating input

P

PaulFort

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.
 
R

Rick B

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
 
G

gls858

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
 
P

PC Datasheet

Try these books:

Using Microsoft AccessXXX, Roger Jennings, Que Corp
Mastering AccessXXX Development, Allison Balter, SAMS
Beginning AccessXXX VBA, Smith and Sussman, WROX
 
P

PaulFort

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.
 
P

PaulFort

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...
 
Top