IsNull Parameter in Crosstab

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top