Saving Calculation Fields Value

  • Thread starter sotto_izi via AccessMonster.com
  • 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....
 
R

Rick Brandt

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

Al Campagna

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