Querying Duplicate

[Archidrb]

I know how to make a query that pulls up duplicates within a table. I also
know how to create a MIN query to pull up the first record in a series.

But I have a table that contains borrowers that can have multiple loans
within the table (Borrower A, loans 1,2,3). I need to create a query that
works like a MIN query, pulling the next record in sequence (based on a
record number and add date), but pulls up all of that next record numbers
loans.

I want to display them in a list form view where additional data is added to
the record. This is a work flow tool. By showing all of the loan records
for a single borrower in the same form we would prevent duplicating work.

Anyone got a solution?

 

[Klatuu]

Your difficulty is caused by an unnormalized database. What you have is a
spreadsheet in Access.
Your table needs to be split into two tables.
You should have a borrowers table that has all the demographic information
on each borrower. Then you should have a Loans table that has all the loan
in formation. The Loans table should have a foreign key field that relates
it to the Borrowers table. Then you would just use a form/subform construct.
The main form would be based on the Borrowers table and the subform on the
Loans table.

A third table would be a transaction table that would contain all the debits
and credits to each loan.

As you are experiencing, a inadequetly normalized database makes your
application much more difficult to build.

I strongly suggest you first design the database, then build your
application on that.