IsNull Parameter with Cross Tab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top