Find next dated transaction for same customer
Results 1 to 2 of 2

Thread: Find next dated transaction for same customer
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2007
    Location
    Oakhurst, New Jersey, USA
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Find next dated transaction for same customer

    I have a table of transactions that include Date and Customer ID. How can I find for a transaction, the next transaction for the same customer?

    For example, a customer might have several transactions over several dates. If I look at any one of those transactions, I need to find the very next dated transaction for the same customer.

    Date-------Next Date
    1/1/19----1/15/19
    1/15/19---2/2/19
    2/2/19----2/3/19
    2/3/19----(blank)

    Thank you.

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,569
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Find next dated transaction for same customer

    maybe post representative example with structure of the data
    or
    try group and max date

    I understand format date is m/d/y ?
    Last edited by sandy666; Jun 27th, 2019 at 10:11 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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