Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Filtering Duplicates (2002)

    Hi,

    I'm in the process of trying to get an unduplicated count on staff. The problem is that staff can have more than one status and/or more than one skill in the database and I need the most current status so I won't count the employee twice. Each status is time stamped. I'm wondering if there is a way to only include the most current status and skill.

    Thanks,
    Leesha

  2. #2
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filtering Duplicates (2002)

    Hi Hans,

    Thanks for the reply but I don't see the atttachement.

    Thanks!

    Leesha

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

    Re: Filtering Duplicates (2002)

    Edited to add attachment. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

    You need two queries for this: a totals query to get the most recent timestamp for each employee, and a query to return records based on the table and the totals query. See attached version.

    Note: the queries are not updateable.

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

    Re: Filtering Duplicates (2002)

    Oops, I clicked "Post It" too soon. Now corrected.

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filtering Duplicates (2002)

    Guess what! You did it again LOL!! I still don't see an attachment.

    Oops myself! Found it!

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

    Re: Filtering Duplicates (2002)

    I added the attachment to my original reply.

  7. #7
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filtering Duplicates (2002)

    Yep! Found it! Thanks a bunch!
    Leesha

Posting Permissions

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