Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    duplicate labels (2000-SR1)

    I have a labels report that is based on a query that has five columns

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: duplicate labels (2000-SR1)

    In the query behind the report, where you set criteria for itemID of 5 or 6, remove the tick from the "show" box, then set the Unique values property of the query to Yes.
    While you include ItemID in the query, the two sets of values returned are not the same, so both are returned when you set unique values to yes.
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: duplicate labels (2000-SR1)

    Bingo! Thanks a bunch!

Posting Permissions

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