Results 1 to 3 of 3

Thread: crosstab query

  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Unanswered: crosstab query

    I have a bit of a problem with a crosstab query. Ive set up a crosstab query to COUNT the number of occurances of a certain critereia, in 2000,2001,2002, etc. My column headings are the year and my row headings are a category. if there are no occurances of that category within a year, the query just shows a blank/null field. When I subsequently create a report from this, the txtbox bound to the query field with a null value obviously shows nothing. The problems is, when I add a "Totals" column to the right hand side of the report, if one of the preceeding fields is null it will not total and of the columnss...any ideas how to get around this?

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Use the Nz function in the Source Control of the txtbox to return 0 when is null.
    =Nz(queryField, 0)
    Saludos
    Norberto

  3. #3
    Join Date
    Nov 2003
    Posts
    10

    Talking

    Thanks very much, I'll give it a go!

Posting Permissions

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