IsNull Parameter in Crosstab

G

Guest

Hello,
I posted this a few days ago, but I don't think it was clear, so here goes.
I have a query that accepts multiple parameters. I would like to add a value
from a crosstab query. As such I have defined the parameters using the
Parameters table that I get by right clicking in my query. The problem is
that some of my parameters may be null. How do I set up this? It won't
accept IsNull(Parameter). Any ideas?
Thanks!
Melinda
 
G

Guest

Well, that was suprisingly easy and boy do I feel dumb. I just had to set
the datatype to Value, which can except null fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top