Results 1 to 2 of 2

Thread: Unique

  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Unanswered: Unique

    Hello All,
    Can anyone assist with any information on how to use the UNIQUE command or statement. I have searched for this in some internet search engines and have not had much luck. Any information on this or any resources I can be directed to would be helpful.

    Thank You

  2. #2
    Join Date
    Oct 2003
    Posts
    311

    Re: Unique

    Originally posted by MissMell
    Hello All,
    Can anyone assist with any information on how to use the UNIQUE command or statement. I have searched for this in some internet search engines and have not had much luck. Any information on this or any resources I can be directed to would be helpful.

    Thank You

    I think its distinct in access :

    This worked for me :

    SELECT DISTINCT tblCkUpload.CkDate, tblCkUpload.Dept
    FROM tblCkUpload
    GROUP BY tblCkUpload.CkDate, tblCkUpload.ckNum, tblCkUpload.Dept;

    In design view of the qrybldr you have to select view from the menu and select totals to get the group by


    M~

Posting Permissions

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