Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Vail, Colorado, USA
    Posts
    173
    Thanks
    27
    Thanked 0 Times in 0 Posts

    12 Month Report Fails if not at least one value for each Month

    I have a report that has as its main part totals for each of 12 Months. The report is based on a cross tab query that has collated al the data it has for each line item. It works fine for years when there is data for each month but not if there is not. For instance I ahem data for 2013 for months 1 and 3 and it stops telling me that it does not recognize 2 . Of course 2 does not exist in the filed list. I have tried a logic test iiF(is error(2),0,2) for each month. that results in putting the month number in the data field. As I sum all the months at the end of the report I have the same problem there.

    Any suggestions appreciated

  2. #2
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Vail, Colorado, USA
    Posts
    173
    Thanks
    27
    Thanked 0 Times in 0 Posts
    Thanks for looking folks. Turns out all iAd to do was enter all the months headings in the properties of month so problem solved

Posting Permissions

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