Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: Access 2k crosstab totalling

    I have created a crosstab query and I want to calculate a total for only specific column fields in that crosstab. I've hard coded field names in the Column Headings property and I'm using these names in the calculated total field. Problem is, if one of these fields is blank, the total doesn't calculate for that row.

    HELP!!!

    Thanks
    Linda

  2. #2
    Join Date
    Dec 2003
    Location
    York PA
    Posts
    11
    Look up the Nz (null) value in the help files. That should solve your problem

Posting Permissions

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