Unbound Controls

  • Thread starter Thread starter Calvin
  • Start date Start date
C

Calvin

Can I store a field that I calculate in a report in a table. More or less
what I want to do is take a stored value on a report and put into a field in
one of my tables. Is this possible?
 
Can I store a field that I calculate in a report in a table. More or less
what I want to do is take a stored value on a report and put into a field in
one of my tables. Is this possible?
Click to expand...

You have asked a very wide open generic question.
Why not take the time to be more specific as to what you wish to do.
And why. Did you wish to Update an existing record or add a new
record to a table?
 
Calvin,
It's not good practice to save calculated fields to your table.
For example... if you had Fields Price and Qty, and Price * Qty =
LineTotal, you wouldn't save the LineTotal value.
You would recalculate LineTotal "on the fly", in any subsequent form,
query, or report.

It probably is possible to use the report's OnFormat event, to examine
your calced value, and Update query your table with that value, but I would
not recommend it.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

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