how do i Calc in fields

[Guest]

Hi
I know it could be simple but i do not know how to do it in access!
My Question is how can i calculate fields?let me explain.
i got two field called "N1" and another Field Called "A1".so i want when i
enter any number in Field "N1" i want in field "A1" show the answer
automatic. And the formal is (number*8) which will be behind field "A1".

Plz help i am new in Access.Thank u so much.

Hassan Merzha

 

[Guest]

Dear Hassan,

Is not a good idea to store information which can be derived from other
fields.
The best way to do this is to have another table containing the codes and
the meaning of each code. Then you can relate those tables and using a query
(in a form lets say) to give you the corresponding answer for any record you
input.

Ο χÏήστης "Hassan Merzha" έγγÏαψε:

 

[Guest]

Fields in a table can not contain formulas. You can have formulas in
queries, forms, and reports.

 

[Guest]

You are "committing spreadsheet". If you want to do something like that,
consider using Excel.