Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Cross tab queries and report (97 sr2)

    I have a cross tab query that works great. I have created a report for the users to print. The user will enter a date range to print the report which pulls from the cross tab query. Every month could be different for the query. for instance: this month I may have a issue about conflict but not next month. So the field conflict would not appear in the cross tab but it is still on the report. I get an error message when there is not data from the query. How can I get my report to display an 0 and not give me an error message if the field does not exist in the cross tab?

    As always....THANKS!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Cross tab queries and report (97 sr2)

    Open the crosstab query in design view.
    Click in an empty part of the upper half of the query design window.
    Activate the Properties window.
    Enter the column headings you want to appear in the query, separated by semi-colons, for example


    If there are no data for a column, it will be blank. If you want zeros, you'll have to use the Nz function in the value field, for example


    You'll have to set the Total option for this column to Expression.

Posting Permissions

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