Re: Crosstab Query Null Values
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Tue, 18 Oct 2005 00:21:45 +0800
The other option would be to add an IN to the Pivot clause, and list the
valid values, e.g.:
PIVOT [Queryfour.Severity/Closure] In (1,2,3,4);
--
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.
"Andibevan" <Andibevan@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uzNziIy0FHA.1028@xxxxxxxxxxxxxxxxxxxxxxx
> Unfortunately, due to the nature of my query I can't access the design
> view
> to try what you suggested.
>
> I have therefore added "WHERE [Queryfour.Severity/Closure] IS NOT NULL"
> but
> this means that the first row is not displayed when there are no records
> present.
>
> Any ideas?
>
>
> TRANSFORM NZ(Count(Queryfour.DefectID),0) AS CountOfDefectID
> SELECT Intervals.Descr AS Range, Count(Queryfour.DefectID) AS Total
> FROM Queryfour RIGHT JOIN Intervals ON (Queryfour.VarAge <=
> Intervals.High)
> AND (Queryfour.VarAge >= Intervals.Low)
> WHERE [Queryfour.Severity/Closure] IS NOT NULL
> GROUP BY Intervals.Descr
> PIVOT [Queryfour.Severity/Closure];
>
> "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
> news:%2394am3i0FHA.3924@xxxxxxxxxxxxxxxxxxxxxxx
>> The <> column represents null values.
>> You can remove them from the query by specifing:
>> Is Not Null
>> in the Criteria row under the Column Heading field.
>>
>> "Andibevan" <Andibevan@xxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:OmGMpXe0FHA.1264@xxxxxxxxxxxxxxxxxxxxxxx
>> >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.
.
- References:
- Re: Crosstab Query Null Values
- From: Andibevan
- Re: Crosstab Query Null Values
- From: Allen Browne
- Re: Crosstab Query Null Values
- From: Andibevan
- Re: Crosstab Query Null Values
- Prev by Date: Re: ansinull and comparing null fields
- Next by Date: Re: Delete Query
- Previous by thread: Re: Crosstab Query Null Values
- Next by thread: RE: Help with displaying list.
- Index(es):
Relevant Pages
|
