- Nov 26, 2004
- Office Version
I'm an Access newbie. I have Access 97 and I'm trying to calculate batting averages, using a query field. Unfortunately, some of the denominators in my data table are either blank or have a zero. I would like a formula that would let me divide Hits by At Bats without getting an error message. My criteria field is set to have a greater than or equal to .300 value. Can anyone help?