Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    need zeros instead of blanks in xtab query (2003)

    TRANSFORM Count(CdK.CodeIntervention) AS CompteDeCodeIntervention
    SELECT CdK.NomEquipe, CdK.Context, CdK.Étape, CdK.Volet, Count(CdK.CodeIntervention) AS Total, Max(CdK.DateModification) AS MaxDeDateModification
    FROM CdK
    GROUP BY CdK.NomEquipe, CdK.Context, CdK.Étape, CdK.Volet
    PIVOT CdK.État;

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: need zeros instead of blanks in xtab query (2003)

    In which column(s)?

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: need zeros instead of blanks in xtab query (20

    in the results generated by the column variable pivot État

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: need zeros instead of blanks in xtab query (20

    Does this do what you want?

    TRANSFORM Nz(Count(CdK.CodeIntervention),0) AS CompteDeCodeIntervention
    ...

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: need zeros instead of blanks in xtab query (20

    Yes thanks hands

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •