Help with Query to get null to = 1

[mkelly]

Attached are screen shots of three queries used to get a percentage of jobs. If there is no jobs within the date range query 3 shows nothing.
Can anyone tell me how if there are no jobs within the date range requested to get the query to give me 100%?

Any help greatly appriciated.

thanks

 

[The_Doc_Man]

I can't download your queries - site rules prohibit same. Try looking at the ISNULL function and put a 1 as the second argument.

 

[mkelly]

The queries are screen shots on a word Doc. I don't understand what the ISNULL function for second argument is and in which query would I put it?

 

[neileg]

I think I'd use Nz().

You have a problem with your queries. There is no join between the queries used as your data source. You will get a Cartesian product, i.e if you have 25 records on one side and 100 records on the other, you will get 2,500 records returned.