IsNull Parameter with Cross Tab

M

Melinda

Hello,
I have a query that takes the total billed from a crosstab query. I'm using
this in conjunction with a parameter query that pulls its parameters from a
form. I've set up my parameters using the parameter table, but it does not
like the usual IsNull([Forms]![FormName]![FieldName]) is there a way to use
Null fields with a crosstab?
Thanks,
Melinda
 
M

Michel Walsh

Hi,


Sure, but for a crosstab, you have to define the data type for each
parameter (here, for [Forms]![FormName]!ControlName ), under the menu, if
you use the query designer: Query | Parameters... Enter
[Forms]![FormName]!ControlName and supply its expected data type.


Hoping it may help,
Vanderghast, Access MVP
 
Top