calculations in access

[Neil_Pattison]

I need to be able to use some functions available in excel in an access 2000 database. These include SUM and IF functions. If any one can help me figure out how to do this any help help wouold be greatly appreciated

 

[SamDeMan]

what is your question?

sam

 

[Neil_Pattison]

The question is how can I use excel functions in access. For example I use the excel formula =IF(C1="Finished",A1,"") to show if C1 is marked as finished this cell would contain the data in cell A1

Any ideas how I can do this

 

[Bat17]

there are If an Sum functions built into Access though in a query you use IIF(). What you dont have are cells!
In a form you could refer to a control
=if([txtDone]="Finished",[txtName],"")

HTH

Peter

 

[neileg]

Just to expand on Bat17's reply:

Formulae can be used in a query or in a form, but not in a table. In normal circumstances you would not store the result of a calculation in a table, you use the query or form to calculate it anytime you need it.

 

[boblarson]

Or you can use them in VBA as well. Use the help file to help you determine how to use it in a query, form, or module.

 

[Neil_Pattison]

Thanks a lot guys everything is sorted now!