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

    Chart/query problem (2003 SP3)

    I'm trying to produce a chart that shows results for each week. Some weeks won't have any values, so I'm linking the query to a lookup table.

    Trouble is, I still can't get the query to list those weeks without any resulting data.

    I've attached a sample if someone could have a look please.

    Thanks in advance

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

    Re: Chart/query problem (2003 SP3)

    Your query and report refer to a text box YearTxt that doesn't exist.

    You are putting conditions on the right hand side of the outer join. This will undo the outer join. You need an extra query to take care of this, and you must put the year condition on the left hand side.

    See attached version.

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

    Re: Chart/query problem (2003 SP3)

    <hr>
    Your query and report refer to a text box YearTxt that doesn't exist.<hr>
    Oops, I guess that's what happens when you rush.

    As for the solution, it's obvious now.

    Thank you

Posting Permissions

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