entering formula into access fileds

[zhuanyi]

Hello,
I am completely new to Access, so thanks to anyone who does not think my questions are dumb
Ok, say for example I have a table that has my income information and my tax rate and I want to compute the income tax I need to pay by simply modifying total income with tax rate, how should I do it? there does not seem to be a function like formular bar in Excel in Access.

Thanks a lot!

Regards,
Anyi

 

[rainman89]

create a query that simply multiplys the 2 fields!

 

[zhuanyi]

By the way, I would like to disable the editing of this field as well, may I know how can I do that? Thanks!

 

[zhuanyi]

Thanks Ray for the quick reply, is there any documentation you could let me know on creating queries? The queries in Access seemed to be quite different from the SQL queries in peoplesoft or SAP...

Thanks!

 

[rainman89]

Essentially, if u can write a query in SQL you can write it in access. there is an sql veiw for queries that u can access by clicking view>sqlview this is when the querydesigngrid is open.

use the query design wizard and add your table to it. then select your fields. see attached photo

 

[zhuanyi]

ok, thanks a lot!