Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    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
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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

    Strife;Conflict;Reconciliation;Acquiescence

    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

    Nz(Sum([FieldName]),0)

    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
  •