Consulting

Results 1 to 3 of 3

Thread: Quick Find of most recent date/time without having to sort.

  1. 04-06-2012, 01:06 PM #1
    Virginal
    Virginal is offline
    VBAX Newbie
    Joined
    Apr 2012
    Posts
    3
    Location

    Quick Find of most recent date/time without having to sort.

    I have a dataset with a large number of rows. I sort this by Shop, Sales Person, DateTime Last Sale.

    I now want to find the most recent "date/time last sale" for each shop, the obvious thing seems to do a pre sort but that seems like using a sledgehammer to crack a nut.

    I want to use the quickest way to find those dates and maybe doing the sort is not so resource hungry as I think.

    All opinions welcome
    Reply With Quote Reply With Quote
  2. 04-06-2012, 05:09 PM #2
    GTO
    GTO is offline
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    Did you try the suggestion Here?
    Reply With Quote Reply With Quote
  3. 04-07-2012, 02:17 AM #3
    Aussiebear
    Aussiebear is offline
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,064
    Location
    Cross posting....... when will they learn?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules