Formulas in Access?

[Guest]

I'm currently transfering the system we use at work from Excel to Access.

We use a lot of formulas to work out certain equations. Can formulas like
these be used in Access and if so, where can I find how to use them?

Thank you.

 

[Matthias Klaey]

I'm currently transfering the system we use at work from Excel to Access.

We use a lot of formulas to work out certain equations. Can formulas like
these be used in Access and if so, where can I find how to use them?

Thank you.

You can use formulas in Forms, Reports, and Queries, and - of course -
in VBA Code. You cannot use formulas in Tables. This is a fundamental
difference to Excel. The "closest" to Excel you come is using
expressions (formulas) in queries.

Go to

http://office.microsoft.com/en-us/access/default.aspx

select yor Access version on the left hand side in the "Help and
How-To" box, then in the middle part "Browse Access Help and How-To",
study the "Expressions" section.

HTH
Matthias Kläy

 

[Guest]

Thank you.