Calculations in forms

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

How do I get accurate calculations that appear in my forms
to populate my tables?

I wasn't sure to put this question under "forms"
or "tables" which demonstrates my lack of awareness.

Any help is much appreciated ,

Jason
 
jason said:
How do I get accurate calculations that appear in my forms
to populate my tables?

I wasn't sure to put this question under "forms"
or "tables" which demonstrates my lack of awareness.

Any help is much appreciated ,

Jason
Click to expand...
There have been many, many posts, in this and other Access newsgroups,
regarding NOT saving computed values to a table.

If you can compute it on a form, or a query, or a report, today using
data which is stored in a table, then re-compute it next week, next
month, etc., whenever needed. That's the normal method to use Access.
While it is possible to store calculated data DO NOT STORE the data
values which can be computed in the future.

Saved computed values take up memory, and can easily become incorrect if
the underlying data values have changed.

If you think your's is the exception to the rule, please post back with
what calculation you are trying save, and I or someone else, will give
the easiest method.
 
Not that we are exceptional, but this may be an exception.

I understand it is better database design to let computed
values be computed and they don't need to be stored.
"let computers compute..."

Here is the control source in the form reads for one
calculation:

=([20# Listening Comp#]+[9# Memory for Words])/2

This is an average of scores from two cognitive tests. It
seems that the form is the best place to do this. Only,
there are some in our lab (my superiors) who would like
calculations to be stored in tables so we can look at them
in columns. We need to query from these calculations and
really never look at the raw scores.

For these reasons it seems the best option is to store the
calculated values in the tables.
I think that I may have to use vba for this which is
beyond my current scope of practice.
 
In response to FredG said:
Not that we are exceptional, but this may be an exception.

I understand it is better database design to let computed
values be computed and they don't need to be stored.
"let computers compute..."

Here is the control source in the form reads for one
calculation:

=([20# Listening Comp#]+[9# Memory for Words])/2

This is an average of scores from two cognitive tests. It
seems that the form is the best place to do this. Only,
there are some in our lab (my superiors) who would like
calculations to be stored in tables so we can look at them
in columns. We need to query from these calculations and
really never look at the raw scores.
Click to expand...

Create a query based on the table and add the calculation to the query.
Then use the query anyplace you would otherwise use the table.
 
I agree with Rick Brandt. Putting the formula in a query
is much like storing a formula in an Excel spreadsheet--
you define it once, then it forever computes the correct
answer from the underlying data.

You can look at the query directly, or create a datasheet
form based on the query which will show the data in
columns. It will appear as if the calculation is actually
in the table. I think that is what your superiors are
asking for.

HTH
Kevin Sprinkel
 
Alright then now i understand how to put calculations into
queries and use them .
Thank you for the help

-----Original Message-----
"In response to FredG"
Click to expand...
message news:[email protected]...
Not that we are exceptional, but this may be an exception.

I understand it is better database design to let computed
values be computed and they don't need to be stored.
"let computers compute..."

Here is the control source in the form reads for one
calculation:

=([20# Listening Comp#]+[9# Memory for Words])/2

This is an average of scores from two cognitive tests. It
seems that the form is the best place to do this. Only,
there are some in our lab (my superiors) who would like
calculations to be stored in tables so we can look at them
in columns. We need to query from these calculations and
really never look at the raw scores.
Click to expand...

Create a query based on the table and add the calculation to the query.
Then use the query anyplace you would otherwise use the table.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
Back
Top