Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Brain dead (Access 97)

    Need to know what to do with a null value in a cross-tab query? I have a cross tab query with Column headings called 24 Hrs, 48 Hrs and 72 Hrs.. These fields are totaled from the row heading called Process time. This query will show the number of reports processed in 24 48 or 72 hrs.. I have another field on the query called ReportTotal.. This field uses a parameter [Enter # of Reports] to show the total number of reports.. So the user just types in the number of reports and it is displayed in the query.. What I need to to is have another field called 24 Hrs which is the ReportTotal field - 48 Hrs - 72 Hrs.. Any thoughts on this.. I evently would like to display this in a report.. Hopefully I made sense here. Thanks for the help..

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Brain dead (Access 97)

    I don't understand. You already have a heading called 24 hrs and you want to have another column called 24 hrs?

Posting Permissions

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