expression

[Guest]

I have an expression that does not work in my form in the field "owe", On
Enter:

=[due]-[paid]

I'm not sure why it won't calculate using these two fields above. Thanks.







=[Subtotal]+[Freight]

 

[Allen Browne]

Put the expression into the Control Source property of the text box, not its
On Enter property.

 

[Guest]

Now the calculated field values on my form (which now work) are not going
back into my table. Thanks.
--
DaveB

Put the expression into the Control Source property of the text box, not its
On Enter property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have an expression that does not work in my form in the field "owe", On
Enter:

=[due]-[paid]

I'm not sure why it won't calculate using these two fields above. Thanks.

 

[Allen Browne]

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains when and how to store calculated fields.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Now the calculated field values on my form (which now work) are not going
back into my table. Thanks.
--
DaveB

Put the expression into the Control Source property of the text box, not
its
On Enter property.

I have an expression that does not work in my form in the field "owe",
On
Enter:

=[due]-[paid]

I'm not sure why it won't calculate using these two fields above.
Thanks.

 

[Guest]

I don't know what "Create a query into your table" means, I have never
created a query in a table before. thanks.
--
DaveB

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains when and how to store calculated fields.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Now the calculated field values on my form (which now work) are not going
back into my table. Thanks.
--
DaveB

Put the expression into the Control Source property of the text box, not
its
On Enter property.


I have an expression that does not work in my form in the field "owe",
On
Enter:

=[due]-[paid]

I'm not sure why it won't calculate using these two fields above.
Thanks.

 

[Allen Browne]

Sorry that expression was not clear for you.

It means, Create a query based on your table.
(The query does not exist in the table; it queries your table.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I don't know what "Create a query into your table" means, I have never
created a query in a table before. thanks.
--
DaveB

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains when and how to store calculated fields.

Now the calculated field values on my form (which now work) are not
going
back into my table. Thanks.
--
DaveB


:

Put the expression into the Control Source property of the text box,
not
its
On Enter property.


I have an expression that does not work in my form in the field
"owe",
On
Enter:

=[due]-[paid]

I'm not sure why it won't calculate using these two fields above.
Thanks.