Auto sum field.

[Guest]

Hi. In a form I've got a text control, and it's dta source is a field on a
table. Everything is working fine.

What I want was to change that field to a excel field. What I mean is,
sometimes I only need to insert a single number, but sometimes I've got to
sum two numbers and then I insert the total in that field. Is it possible to
insert (+350+150) and the fields automatically sum and insert the total, so
it only appears (500).

I'll try to resume, instaed to insert the total of 500 can I insert 350+150
and appears 500?

Marco

 

[Roger Carlson]

No you can't. Although Access tables look like Excel spreadsheets, they are
very different animals.

However, you can create a popup box that will allow a user to type in an
expression (300+500) and it will evaluate the expression and put the answer
in the text box.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExpressionEvaluation.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

You're the man. Thanks.
Appreciatted

Marco

No you can't. Although Access tables look like Excel spreadsheets, they are
very different animals.

However, you can create a popup box that will allow a user to type in an
expression (300+500) and it will evaluate the expression and put the answer
in the text box.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExpressionEvaluation.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L