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
 

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

Similar Threads

IsNull Parameter in Crosstab 1
Multiple Parameter Crosstab query filter by form 1
USING PARAMETERS IN A CROSSTAB QUERY 4
Parameter Value in Crosstab Query 4
crosstab query with parameter query 5
Parameter Query 1
Parameter Query from Form 2
Parameterizing in a Cross Tab Query 2

Back
Top