Results 1 to 3 of 3

Thread: Compare two records from same table?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2014
    Posts
    389
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Compare two records from same table?

    Is it possible to compare two records from the same table?
    For example:
    I have a database with a table called STEP1.
    The table contain columns: STEP1_ID, Amount1, Amount2, Date

    If my record have the values like this:
    ID=1, Amount1 = 500, Amount2 = 300, Date = 2019-03-01

    Now i want to compare this record to another record.
    Compare Amount1 and 2 to another record (row). So i can get the difference between the values.

    Each record is for me a Repport. Each repport contains values that i want to compare to other repports so i can see any big fluctuation.

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,812
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Compare two records from same table?

    Here is a link to Allen Browne's web site that talks to that issue

    http://www.allenbrowne.com/appevent.html
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


  3. #3
    Board Regular
    Join Date
    Dec 2014
    Posts
    389
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Compare two records from same table?

    Found a solution to use a combobox to populate controls from another record than the current one viewing. that way i can create a view where the user can load one record and bring up data from another record and then i can either do calculations to compare the different data or just create views/reports.

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
  •