how to do this? a calculated value to a field.

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I am trying to make a database in access that is currently in Filemaker Pro.
When I made the filemaker one several years ago, I had to write scripts for
fields in the table to make calculations.
Example: If field1(certificate expires)=today+30 days, then field2= cert
expiring.

How is this accomplished in Access? Do I make a form that has vba to read
other fields in the form?

I need a starting point.

Thanks,
Rob
 
There is no way to do this in a table. Also, it is bad form to store data
that you can calculate. There are a few exceptions for historical data where
the input values may change. Use a calculated control on a form or report to
display the data you are after. The calculation can be done in the control
or in the query feeding the form or report. Doing this in the query will
make the query "not updateable", which won't work if you are using a form
and want to edit the values.
 
Wayne Morgan said:
There is no way to do this in a table. Also, it is bad form to store data
that you can calculate. There are a few exceptions for historical data where
the input values may change. Use a calculated control on a form or report to
display the data you are after. The calculation can be done in the control
or in the query feeding the form or report. Doing this in the query will
make the query "not updateable", which won't work if you are using a form
and want to edit the values.
Click to expand...

Huh? Doing a calculation in a query only renders the calculated field not
editable, not the entire query. You would have to be using a Totals query
for the entire query to become non-editable.
 
Thank you. I will give it a shot.
Rob


Wayne Morgan said:
There is no way to do this in a table. Also, it is bad form to store data
that you can calculate. There are a few exceptions for historical data where
the input values may change. Use a calculated control on a form or report to
display the data you are after. The calculation can be done in the control
or in the query feeding the form or report. Doing this in the query will
make the query "not updateable", which won't work if you are using a form
and want to edit the values.
Click to expand...
 
Back
Top