expression

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dberger16 - 08 Dec 2005 14:50 GMT

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]

Signature

DaveB

Reply to this Message

Allen Browne - 08 Dec 2005 15:00 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
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.

Reply to this Message

dberger16 - 08 Dec 2005 15:36 GMT

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

Signature

DaveB

> Put the expression into the Control Source property of the text box, not its
> On Enter property.
[quoted text clipped - 5 lines]
> >
> > I'm not sure why it won't calculate using these two fields above. Thanks.

Reply to this Message

Allen Browne - 08 Dec 2005 15:59 GMT

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

The article explains when and how to store calculated fields.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
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.
[quoted text clipped - 11 lines]
>> > I'm not sure why it won't calculate using these two fields above.
>> > Thanks.

Reply to this Message

dberger16 - 08 Dec 2005 17:05 GMT

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

Signature

DaveB

> See:
> Calculated fields
[quoted text clipped - 18 lines]
> >> > I'm not sure why it won't calculate using these two fields above.
> >> > Thanks.

Reply to this Message

Allen Browne - 09 Dec 2005 01:14 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
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.
[quoted text clipped - 24 lines]
>> >> > I'm not sure why it won't calculate using these two fields above.
>> >> > Thanks.

Reply to this Message