Creating a report

[steve]

If this is a duplicate post, I apologize...it appeard as though I timed out
previously

Hi All:

I am still a relative novice at Access.

I have a loans database with two tables in it: Customers and LoanDetail.
These tables have a one-to-many relationship.

I am trying to create a report in Access that will show the customer, the
total loan balance outstanding, and the collateral we have, all on one line,
per customer. By using a query and grouping on the customer name, and using
the built-in sum function on the balance field, I can get those two columns
in the report to display the information I want the way I want it. However,
when I add the collateral field, it only reports the collateral for one of
the loans, instead of showing all of the collateral.

I hope I have provided sufficient info for someone to help me with this
problem.

TIA

Steve

 

[Duane Hookom]

I think you may need to add the collateral as a subreport in the main
report.

 

[steve]

Thanks for responding, Duane. I thought about that, but can't get a
sub-report to display properly. I've also tried a sub-query, but that did not
do the trick either.

If I was going to lay this report out at a web site, I think I could get it
to work right using a do while loop, but have no idea how I might do this in
an access report.

Steve

 

[BabyATX13 via AccessMonster.com]

Do you have a collateral table?
If not it may be wise to create one, because one loan may have more than
one collateral, that way it might be easier to make your sub report work.
KB

 

[SteveG]

Thanks KB..I'll see if that makes this any easier.

Steve

 

[Duane Hookom]

I am totally confused regarding your tables/fields, what your data might
look like, and what you would expect to see in a report. If you take the
time to provide this information someone might be able to help you.