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

    Unanswered: Date Difference from same column

    Dear all, I've a table like below. Could anyone tell me what will be the query to get the date difference of last two payment dates of distinct user ID.

    user_id amount_paid payment_date
    X 102 11/2/13
    A 89 18/2/13
    X 93 15/2/13
    X 85 17/1/12
    Z 87 19/2/13
    A 86 3/1/13
    A 78 13/1/13

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    pbaldy, a member here, has a demonstration that you can download here:

    Previous values

    Download the sample database, click on the button, as instructed, which opens a Query. Go into Design View for the Query and see how to pull the previous value by looking at the code behind the Calculated Query Field named PrevEnd.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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