Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Sep 2004
    Location
    Louisville, Kentucky, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charting a query using an expression (2000)

    I have created a query that calculates a percentage. I want to make a chart of the percentages per day. However, the wizard does not recognize the expression as a percentage and will not allow me to use anything but count. the error message says the expression is either date, text or a key field. How can I get this to work?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Charting a query using an expression (2000)

    Without more detail, such as how you are calculating a percentage, it's pretty difficult to guess what is going on. Are you simply formatting the result of an expression as a percentage, or are you creating a decimal value and then multiplying it by 100? Access charting will normally offer to display a percentages chart if you give it a decimal value between 0 and 1.
    Wendell

Posting Permissions

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