I am trying to get the following statement to work:

 

If {tblTransmissionMaster.CutDollars} = 0 then
0
Else
{tblTransmissionMaster.CutDollars} / {tblTransmissionMaster.CutAcres}

I get the division by zero error and I am not sure why.

 

Also I have the following field in my database I want to query on {tblTransmissionMaster.CategoryCode}, I want to get the average cost of cut acres for category TM. How do a write the syntax to show the average for category TM only. Below is what I tried but I know it is wrong:

 

{tblTransmissionMaster.CategoryCode}   = tm

and

Any help would be appreaciated!