Access 2003

  • Thread starter Thread starter ed the beginner
  • Start date Start date
E

ed the beginner

I have a field in one form that is calculating the difference in days between
two other columns.
1. Can I write the same expression in the table? How? ( in the table I don't
have the values from the form for the same field and I can't run a query or a
report )
2. It is possible to have a macro or something, to search records and
display in a different form ( or warning ), only values between "minus 10 and
5"?

Thank you all for support.
( I don't know VBA )
 
ed the beginner said:
I have a field in one form that is calculating the difference in days
between
two other columns.
1. Can I write the same expression in the table? How? ( in the table I
don't
have the values from the form for the same field and I can't run a query
or a
report )
2. It is possible to have a macro or something, to search records and
display in a different form ( or warning ), only values between "minus 10
and
5"?

Thank you all for support.
( I don't know VBA )
Click to expand...


There's no need to store the difference between the two columns, because
that can always be calculated whenever you need it. Storing calculated
values, when they are solely dependent on other fields, is generally a bad
idea, because it opens the door to subsequent updates that may render the
calculated value incorrect.

I suggest you create this as a calculated field in a query. Let the query
do the calculation, base your form on that query, and bind the control on
that form to the calculated field.

It would be easy to run a second query on that query to return records that
have values between -10 and 5 in that calculated field.
 
Back
Top