Search results

I spoke too soon! I tried method one and it returns a value of #name? each time I open the report. I will move on to method two. Thanks again. tony. [This message has been edited by amayer (edited 07-11-2001).]

You need the null value function which is Nz. I believe that your function would be =Sum(Nz[Invoice Amount 3]). You can look up the Nz function in the help too. Tony

I want to create a report which asks the user a series of questions, and which will display the answers in the report. This is for manually creating shipping forms for items which don't need to be in a tablespace anywhere. I have gone the long way with creating query's macro's table's form's...

I found that I was putting the parens in the wrong place. It works as =(count([item1])+count([item2])). Tony.

I have a need to count the total of displayed items on a report. I have a total of seven fields which may contain data. They can be null, so the expression needs to be able to handle the null value. I am able to get a total of 0 which I think is because of the null values, but have been...