Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    2

    Problem in Table Joining

    Hi

    I have a table Stocks containng col.. (PID,SDate,Quantity). I want distinct PID with Max date.

    e.g. PID SDate Quantity

    1001 12/23/2012 40
    1001 12/25/2012 25
    1002 12/25/2012 80

    I want 1001 12/25/2012 25 and 1002 12/25/2012 80 value.

    FrontEnd: VB 6.0
    Database: Ms-Access 7

    pls help.

    Thannks
    DemoK

  2. #2
    Join Date
    Feb 2013
    Posts
    2
    Hi

    can't anybody help me out from this problem.

Posting Permissions

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