Compare two records from same table?

[behedwin]

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.

 

[alansidman]

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

http://www.allenbrowne.com/appevent.html

 

[behedwin]

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.