Saving Calculation Fields Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sotto_izi - 08 May 2007 13:06 GMT

hi..
im having a hard time making a database system using only full access..
im not allowed to use any VBA codes.. now im having difficulty on calculation
fields in a form.. it is said that calculation fields are not stored in a
table.. my question is how can i get the value of that field if ever i have
to create another form where i need its existing value.. it would be if easy
i can find it in a table but like i said it only exist in the form.

please help me with this.. thanks....

Reply to this Message

Rick Brandt - 08 May 2007 13:25 GMT

> hi..
> im having a hard time making a database system using only full access..
[quoted text clipped - 5 lines]
>
> please help me with this.. thanks....

Create a SELECT query based on your table and add to it all of the table's
fields PLUS a calculated field using the same expression that you are using on
your form. Now just use that query everyplace you would otherwise have used the
table.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Al Campagna - 08 May 2007 13:56 GMT

sotto,
Say the calculation was Price * Qty = LineTotal. You calculate LineTotal "on the fly"
with an unbound calculated field.
On another form you would use the same two fields, Price & Qty to calculate the
LineTotal, just like you did on the original form. You can do that in any subsequent
form, query, or report.

Signature

hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

> hi..
> im having a hard time making a database system using only full access..
[quoted text clipped - 5 lines]
>
> please help me with this.. thanks....

Reply to this Message