Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: Distinct Rows Query issue

    Hi,
    I have query that 3 columns, the first is the productNo, Description and Type.

    I am trying to get distinct ProductNo. but I am unable to because, Description is either spelled in all CAPS or as some other minor things.

    What I am trying to do is get the first Distinct ProductNo and have one of the Descpriptions displayed.

    thank you
    ======================
    Levent
    Access 3

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    Create a "totals" query by pressing the button that looks like a greek E. Select "Group By" for the ProductNo and "First" for Description.

Posting Permissions

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