Percentage in Access Help

--------------------------------------------------------------------------------

I need help.

I have several Excel formulas that I need to use in Access. I am not sure just how to do it. What I need to do in Access is find the percentage for two or more fields in my data base.

Here are the Excel formuals

=IF(B10=0,"0",(B9+B10/B8)
=IF(B13=0,"0",B13/10)
=IF(B16=0,"0"B16/(B10+B9))

These are seperate formulas for 3 different field in data base.
I hope I am making sence.

Thanks ahead for your help. I am really in a crunch, need to finish this data base soon.

The syntax in your query will be very similar Excel by using the immediate If statement

IIf(Condition,True Part, False Part)

So in your above examples you would use the actual field name not the cell location that is used in Excel

IIf([FieldName10] = 0 , 0, (FieldName9 + FieldName10)/FieldName8)

lwells