Saving Calculation Fields Value

  • Thread starter Thread starter sotto_izi via AccessMonster.com
  • Start date Start date
S

sotto_izi via AccessMonster.com

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....
 
sotto_izi via AccessMonster.com said:
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....
Click to expand...

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

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