G
Guest
Hello all -
I am a fairly new Access user (just familiar with the basics). I just
returned from vacation this morning and am facing an Access question that is
completely stumping me.
My supervisor would like to report on data that exists in 3 tables. While I
was gone she used this information to create a table with 2 subdatasheets
within it. The first table contains information for primary borrowers at our
bank. On the primary borrower table is also a list of financial tracking
items tied to their loans. The second table contains a list of the
guarantors that are listed on each primary borrower's accounts. The third
table contains guarantor information and the financial tracking items tied to
each guarantor.
Currently, the main table contains the primary borrower's information. When
you click the plus sign next to a primary borrower's name, you get a list of
the guarantors on their loan. When you click the plus sign next to the
guarantor's name, you get a list of the tracking items for the guarantor.
This seems like a nice and organized way to store the information we need,
but I'm not sure how to manipulate it from this point.
I want to create a report that shows the primary borrower's name, account
number, and tracking items. Below that, I want to show the names of the
guarantors tied to the primary borrowers and the tracking items for each
guarantor. I'm struggling to find a way to do this without duplication. I
also don't know if the subdatasheet format my supervisor was working on is
going to be helpful, although it seems to display the information in an
accurate and accessible way.
Sorry for the lengthy description - any tips on how to proceed would be
greatly appreciated. Thanks!
Sarah
I am a fairly new Access user (just familiar with the basics). I just
returned from vacation this morning and am facing an Access question that is
completely stumping me.
My supervisor would like to report on data that exists in 3 tables. While I
was gone she used this information to create a table with 2 subdatasheets
within it. The first table contains information for primary borrowers at our
bank. On the primary borrower table is also a list of financial tracking
items tied to their loans. The second table contains a list of the
guarantors that are listed on each primary borrower's accounts. The third
table contains guarantor information and the financial tracking items tied to
each guarantor.
Currently, the main table contains the primary borrower's information. When
you click the plus sign next to a primary borrower's name, you get a list of
the guarantors on their loan. When you click the plus sign next to the
guarantor's name, you get a list of the tracking items for the guarantor.
This seems like a nice and organized way to store the information we need,
but I'm not sure how to manipulate it from this point.
I want to create a report that shows the primary borrower's name, account
number, and tracking items. Below that, I want to show the names of the
guarantors tied to the primary borrowers and the tracking items for each
guarantor. I'm struggling to find a way to do this without duplication. I
also don't know if the subdatasheet format my supervisor was working on is
going to be helpful, although it seems to display the information in an
accurate and accessible way.
Sorry for the lengthy description - any tips on how to proceed would be
greatly appreciated. Thanks!
Sarah