Show certain information for each bank?

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top