C
Casey
SH,
First, let me tell you that in your message you
express that you want to subtract the [# of claims] from
20, and then you iterate the [# of claims] - 20
calculation which is backwards of what you said you want.
What you can do is if you want that calculation to be
an actual piece of information, place your table in a
query, along with all of the fields you are interested
in. After you have placed all of the fields in the query,
in the next free column, on the top line, instead of
placing a field name, use this to subtract the number of
claims from 20:
Expr1: 20 - [# of Claims]
If you want to subtract 20 from the number of claims
use the following:
Expr1: [# of Claims] -20
That is called using an expression.
Now, save the query, and make it the source of your
form, and place all of the fields and the Expr1 expression
on your form. It will them be present just as all of your
other fields.
I hope this information helped you.
Good luck,
Casey
First, let me tell you that in your message you
express that you want to subtract the [# of claims] from
20, and then you iterate the [# of claims] - 20
calculation which is backwards of what you said you want.
What you can do is if you want that calculation to be
an actual piece of information, place your table in a
query, along with all of the fields you are interested
in. After you have placed all of the fields in the query,
in the next free column, on the top line, instead of
placing a field name, use this to subtract the number of
claims from 20:
Expr1: 20 - [# of Claims]
If you want to subtract 20 from the number of claims
use the following:
Expr1: [# of Claims] -20
That is called using an expression.
Now, save the query, and make it the source of your
form, and place all of the fields and the Expr1 expression
on your form. It will them be present just as all of your
other fields.
I hope this information helped you.
Good luck,
Casey