Re: Crosstab Query Null Values

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.
>
> --
> 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: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.
>
>


.

Relevant Pages

  • Re: A single report for several queries
    ... Now, save the report with its RecordSource property blank, i.e. it has no ... and see if the correct query name is printed. ... > set the control source to the required query and comment out the code ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.reports)
  • Re: Help with counting only one time
    ... You want to exclude all but the first row for each order? ... In the following example, I will assume there is a primary key field named ID, and the table is called Table1. ... but I am clueless on what to do in the query even ...
    (microsoft.public.access.queries)
  • Re: "Numeric field overflow."
    ... Number data type, which really screwed up the works because the column in ... What was really nutty was that the append query ... However, if you tell it that the first row is a header row, ... If the source query has calculated fields, you may need to typecast the ...
    (microsoft.public.access.queries)
  • Re: "Numeric field overflow."
    ... Then query the temp table to ensure the data in every ... area - linked Excel spreadsheets. ... However, if you tell it that the first row is a header row, ... If the source query has calculated fields, you may need to typecast the ...
    (microsoft.public.access.queries)
  • Re: Non US Date Field Problem
    ... and explains how to avoid the 3 common traps. ... rather than allenbrowne at mvps dot org. ... Im looping through a recordset using ... > some of the values as criteria to run an query in each iteration. ...
    (microsoft.public.access.queries)