R
RobertG
My database is used for processing monthly claims from clients and making
payments via a report. Users must enter in the month they are paying and the
amount for that month for a particular client. I have the report pointed to
a query that looks at the client, amount, month, other info and a column on
the table that houses this info that tells if this particular month/amount
has been printed for this client. Once the report is ran and printed, an
append query changes the "no" in the printed field to a "yes" so that it will
not be looked at, again. I, currently, have my report set up, so that it can
only print ONE month, ONE amount, for ONE client at a time onto the report.
With that out of the way, I will pose my problem. Often times, clients will
submit claims for payment late, or for whatever reason, we will have to go
and pay multiple months at a time. Is there a way to make the
report/query/anything see that more than one month/amount must be printed for
the client and put them onto a separate line on the report?
example:
Client
Address
Month Amount
Month Amount
Month Amount
As stated earlier, all I have been able to come up with is a report that
will print each month/amount and all accompanying info onto a seperate page,
completely.
Any advice is welcome and I can always offer more info, if needed. Thanks
in advance!
payments via a report. Users must enter in the month they are paying and the
amount for that month for a particular client. I have the report pointed to
a query that looks at the client, amount, month, other info and a column on
the table that houses this info that tells if this particular month/amount
has been printed for this client. Once the report is ran and printed, an
append query changes the "no" in the printed field to a "yes" so that it will
not be looked at, again. I, currently, have my report set up, so that it can
only print ONE month, ONE amount, for ONE client at a time onto the report.
With that out of the way, I will pose my problem. Often times, clients will
submit claims for payment late, or for whatever reason, we will have to go
and pay multiple months at a time. Is there a way to make the
report/query/anything see that more than one month/amount must be printed for
the client and put them onto a separate line on the report?
example:
Client
Address
Month Amount
Month Amount
Month Amount
As stated earlier, all I have been able to come up with is a report that
will print each month/amount and all accompanying info onto a seperate page,
completely.
Any advice is welcome and I can always offer more info, if needed. Thanks
in advance!