Hi, I have a report that is based on a query where I have used IIf(IsNull). When I look at the query it is giving me the records that I want, however when I open the report that is based on the query I get a parameter dialog box. If I click OK to close the box and open the report, the report comes up with all the fields blank, if I enter a paramter all records end up with the info that I have inputted. Niether result is what I want. Any help would be gr8? Thx
Tina
Tina