All -
I have a sheet that has cells that have data (numbers) and some that do not. When doing a sum, I'm getting a #Num! error I believe because access is reading the "empty" cell as 0 and consequently giving 0/0 = !Num#.
To eliminate the error (because I'm trying to link this query to an excel sheet) I have tried IsError nested in an if statement, which did not work. I also tried using IsEmpty to distinguish between an empty cell and a cell with a variable, but both return the same value.
Help!