Set a default value for a text box in a report

[beacon]

Is this possible? If not, is there a way I can use IsNull or something like to return zero if there aren't any instances of what my query is returning?

Here's what I have in the text box in the details section of my report:

=DLookUp("CountOfSkillLevel","qrySkillsWF","SkillLevel = 'Beginner' AND Program = '" & [Program] & "'")
 

If there haven't been any users entered with the skill level of beginner I'm looking to have the report output zero instead of nothing.

I'm not great at expressions in Access 2003, or expressions for that matter, because all of my reference books don't spend any time on them at all.

I tried an IsNull statement, but it changed all of my values in the report to zero even if they weren't supposed to be Null. I know that this is because I didn't set it up correctly, but for learning purposes I will post my faulty expression. Here it goes:

=IsNull(DLookUp("CountOfSkillLevel","qrySkillsWF","SkillLevel = 'Beginner' AND Program = '" & [Program] & "'")=0)
 

I'm sure I have to use an IIf statement or something, but I can't find anything that will assist me in writing it. Again, I'm not so good with expression.

Thanks everybody...

[nico5038]

Hmm, I don't see the lookup value as a proper parameter in your last line of code.
I would have used:

=NZ(DLookUp("CountOfSkillLevel","qrySkillsWF","SkillLevel = 'Beginner' AND Program = '" & [Program] & "'"),0)
 

Nic;o)

[beacon]

I ended up changing one of my tables to more closely reflect the output I desired and created a query from that. Then, when I used the DLookup, my numbers were correct.

Thank you for your help Nico...

[nico5038]

Well done beacon :-)

Success with your application !

Nic;o)

[beacon]

Hmm, I don't see the lookup value as a proper parameter in your last line of code.
I would have used:

=NZ(DLookUp("CountOfSkillLevel","qrySkillsWF","SkillLevel = 'Beginner' AND Program = '" & [Program] & "'"),0)
 

Nic;o)

I'm just curious because I ended up using the NZ part of your equation, but what does the NZ stand for??

Edit *******************************************

Nevermind, I found the Nz method in the MSDN. It's interesting.....makes me wish I would have stumbled upon it long ago.

Thanks again Nico and everyone else for that matter.