substraction function in access 2002 table

[hungry newbie]

Hi everyone!
I am new and I am also learning Access on my own as I go.

I created a table. Now I have three columns:
Pbias Nbias Netbias

I want Netbias to be a value given by the substraction of Pbias-Nbias

I figured the function for the Netbias would be like in excel:
=(Pbias)-(Nbias)

I tried entering this in the validation tab under design view but I got an
error and did not work.

Question#1: Am I doing it wrong? How do I accomplish this?

Question #2: Do I have to create the same function if users will be entering
data on the form instead? or will it show the Netbias result already?

Thanks a lot!

 

[Beetle]

Am I doing it wrong?

Yes

How do I accomplish this?

You don't do calculations at the table level. You do them in
queries, forms and reports. In your case I would suggest
using a calculated field in a query like;

NetBias: [PBias] - [NBias]

Then use the query as the record source for your form.

 

[fredg]

Hi everyone!
I am new and I am also learning Access on my own as I go.

I created a table. Now I have three columns:
Pbias Nbias Netbias

I want Netbias to be a value given by the substraction of Pbias-Nbias

I figured the function for the Netbias would be like in excel:
=(Pbias)-(Nbias)

I tried entering this in the validation tab under design view but I got an
error and did not work.

Question#1: Am I doing it wrong? How do I accomplish this?

Question #2: Do I have to create the same function if users will be entering
data on the form instead? or will it show the Netbias result already?

Thanks a lot!

Access is not a spreadsheet. You never do calculations in a table.
Your expression is fine, just use it in an UNBOUND control on a form
or report, or in a query.
And ... do not save that value. Anytime you need to know the results
of =[Pblas] - [Nblas] repeat the calculation.