[AccessD] CrossTab

You can also investigate the 'Switch' command, switching a <NULL> value for
an actual text string like "Null".

> -----Original Message-----
> From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
> Sent: Wednesday, October 08, 2003 7:56 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 

This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you. ACS8/10/2003