[AccessD] CrossTab

Is the crosstab using the values as the column headings?  If so, you
could use a calculated field to return an IsNull expression.

Charlotte Foust

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk] 
Sent: Wednesday, October 08, 2003 7:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] CrossTab 


I need to keep the nulls as they are valid responses.

Martin


----- Original Message ----- 
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, October 08, 2003 4:38 PM
Subject: Re: [AccessD] CrossTab


> Can't you handle the Null in the underlying query?
>
> Susan H.
>
>
> > Running a major cross tab report
> >
> > A lot of the values are null
> >
> > Problem
> >
> > The Crosstab creats a new column called <> (I dont create this)
> >
> > when it comes across a null row it assigns it a value of 1
> >
> > how can I get it to stop creating the 1 value as it is tossing out 
> > my calculations.
> >
> >
> >
> > Martin
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com