Re: Crosstab Query Null Values

I have the same problem but also need to know how to get rid of an extra
column that has a "<>" at the top of it.

Thanks

"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:ORo4V$hzFHA.2132@xxxxxxxxxxxxxxxxxxxxxxx
> Switch the crosstab from design to SQL View (View menu).
>
> Add Nz() around the expression in the first line, e.g. change:
> TRANSFORM Sum(tblInvoiceDetail.Quantity) AS SumOfQuantity
> to:
> TRANSFORM Nz(Sum(tblInvoiceDetail.Quantity), 0) AS SumOfQuantity
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Trever B" <TreverB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:05A90EFC-1B70-401A-BADF-0F9146B6C1E7@xxxxxxxxxxxxxxxx
> > When I do a cross tab query it gives me a null if a record does not
exist.
> >
> > How do I change the Null to 0
>
>


.

Relevant Pages
Loading