Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart from Union Query (2003 SP1)

    I'm having difficulties trying to chart a union query. The query runs fine but trying to get a chart to work gives me an error message;
    "invalid scale for decimal date type"

    MSKB has only the one article with this error & it's not applicable (relates to Infomix ODBC, which this has nothing to do with).

    The error only applears to come from one field; a totaled weight field. I've checked that the source fields have the same number format, but no difference.

    TIA
    Paul

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart from Union Query (2003 SP1)

    Are the tables the union query is based on Access tables, or are they links to another database type?

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart from Union Query (2003 SP1)

    The queries are all on internal data. Though that data was pulled from an AS/400 server.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart from Union Query (2003 SP1)

    If you open the tables in design view, and inspect the data types and field sizes, are there any number fields with field size = Decimal? Decimal is not a "native" Access data type, and although it is supported, there can be problems in using it.

  5. #5
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart from Union Query (2003 SP1)

    Yep that's it. Changed it to singel & Bob's your uncle.

    Only trouble is I've now lost the order I wanted. The query brought togther weekly data (weeks 1 - 51) & the average from the previous year. I managed to arrange the query so I got the year average first, then the weeks, but the chart has it sorted by number.

Posting Permissions

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