Formulas in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Charlotte said:
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.
Click to expand...

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
 
Back
Top