Deadline Approaches...Help!

[Guest]

I'm creating a database for Animal Licenses for a City and the time to begin
is getting close. I've managed to figure out, with help from this group, most
of what I need to accomplish, but one major thing I haven't. A license
document when printed could have possibly 3 fee amounts on it. And, I don't
know how to do this. All 3 amounts would have the same date, so I based the
report on a query with the Fee Date as one of the criteria. It works fine
when there's only 1 fee record, but I don't know how to print a line for each
fee record when there's more than 1. I need to be able to print a line that
shows the type of fee and the amount and then print a total line. I know how
I would do this in Cobol, but I'm on shaky ground doing this in Access. I
could really use yall's help on this one. I've learned so much already from
this discussion group and I appreciate everyone's time and patience with my
endless stream of questions. But, I've always been of the mind, if you don't
know, don't be afraid to ask. So I have and yall have answered. Thanks for
all the previous help yall have given me.

Thanks,
RandyM

 

[Ken Snell \(MVP\)]

Use a subreport for that part of the report. The subreport's recordsource
would be a query that returns the fees for each license. You then link the
subreport to the main report via the related fields.