Calculated value become field entry

  • Thread starter Thread starter Rick Brandt
  • Start date Start date
R

Rick Brandt

MM said:
Using one table, I want to take the value entered into two text boxes
Field1 and Field2 and calculate the entry to be used for Field3. In
my form I have a Text Box's control source property which works
properly.....

=([Field1]*[Field2])+1

How do I get a caculated value in the form to become data entry for a
field? Perhaps I have this backaward- I should calculate the value in
the table and display it back to the form? But how?
Click to expand...

Calculation results are not stored. Put your expression in a query based on
your table and then use the query instead of the table wherever you need
that value.
 
Using one table, I want to take the value entered into two text boxes Field1
and Field2 and calculate the entry to be used for Field3. In my form I have
a Text Box's control source property which works properly.....

=([Field1]*[Field2])+1

How do I get a caculated value in the form to become data entry for a field?
Perhaps I have this backaward- I should calculate the value in the table and
display it back to the form? But how?

Thanks,

MM
 
I am using the form to enter data used to create the calculation-- but I
would be unable to calculate field3 via a query until the record has been
entered into the table. I am new to this so may be I am missing something?
I can get calculated results to store using the "default value" using
something simple like =2+2 but I cant get it to store using my formulat
below. I must be doing something wrong.

Thanks for your help

Rick Brandt said:
MM said:
Using one table, I want to take the value entered into two text boxes
Field1 and Field2 and calculate the entry to be used for Field3. In
my form I have a Text Box's control source property which works
properly.....

=([Field1]*[Field2])+1

How do I get a caculated value in the form to become data entry for a
field? Perhaps I have this backaward- I should calculate the value in
the table and display it back to the form? But how?
Click to expand...

Calculation results are not stored. Put your expression in a query based
on
your table and then use the query instead of the table wherever you need
that value.
Click to expand...
 
MM said:
I am using the form to enter data used to create the calculation--
but I would be unable to calculate field3 via a query until the
record has been entered into the table. I am new to this so may be I
am missing something? I can get calculated results to store using the
"default value" using something simple like =2+2 but I cant get it to
store using my formulat below. I must be doing something wrong.
Click to expand...

What you should be storing is field1 and field2. The result of field1*field2
can always be calculated afterwards so there is no reason to save it.
 
I see your point. It would really make my life easier to have it come from
the table- I think.

The problem I am trying to solve- I want to use Access' graph reporting
features to graph the calculated results of field1*field2. I know how to do
this if the value I am looking to graph is pulled from a table. Do you know
a way for me to make this possible? I figured how to do it with standard
text reports, but not graphs.

Thanks
 
MM said:
I see your point. It would really make my life easier to have it
come from the table- I think.

The problem I am trying to solve- I want to use Access' graph
reporting features to graph the calculated results of field1*field2. I know
how to do this if the value I am looking to graph is pulled
from a table. Do you know a way for me to make this possible? I
figured how to do it with standard text reports, but not graphs.
Click to expand...

So build your graph based on a query instead of a table.
 
Do I understand correct-- query the db which will return field1 and field2
for all records in the db; this same query would then multiply field1*field2
for each and every record of the db; this same query would use the return
values to feed into Access's report functionality that generate the graph in
Accesss? Before I set off to figure out how to do this- let me know if I
understand what is being suggested.

Thanks for your time.
 
MM said:
Do I understand correct-- query the db which will return field1 and
field2 for all records in the db; this same query would then multiply
field1*field2 for each and every record of the db; this same query
would use the return values to feed into Access's report
functionality that generate the graph in Accesss? Before I set off
to figure out how to do this- let me know if I understand what is
being suggested.
Click to expand...

Yes, when you start the graph wizard just point it at a query instead of a
table.
 
Back
Top