Show certain information for each bank?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Each bank is associated with a bank number for which we established 6
different numbers. Examople: 4006-xxxxx, 5006-xxxxx, 7006-xxxxx and
8006-xxxxx depenting on thier location or zone. Each bank carries business
loans and if a business has an outstanding loan it is assigned a number
between 1 and 5. If it is paid off it is assigned a different number between
5-10. If it will be paid off in less than 6 months it is assigned another
number between 1-6. Then we have different numbers for such things as late
payments, payments past 30, 60 90 days etc.
I have 3 tabs for each of the above (paid off, not paid off, will be in 6
month or less). I want to be able when we select the bank number to have all
of the tabs load up the correct infomatin and numbers based on certian
expression I provide. Is there an easy way to do this in code?
 
You gave a bunch information on your number scheme but nothing on how you are
recording this data in Access.
What are your table names, field names and datatype, and relationships
between tables.
 
Back
Top