S
Suthee
Hi everyone,
I have a table "InvoicesToBePaid". It contains a list of clients with
invoices that need to be paid based on terms. The records were appeneded to
this table with a query that computed and appeneded a pay date to a field.
Now I don't want to issue a separate check for each invoice when a client
has mulitple invoices that pay the same day. I have a custom report that
prints to my check stock that groups them by client so one check can pay
multiple invoices for the same client..
The Check number is on my check stock. I want to somehow enter the starting
number, of the check numbers, for instance 100. After the checks print, a
query must update each record with the appropriate check number, but it must
mark them in sequence (autonumber from my starting point), and mark the
invoices that were paid together on one check all with the same check number
before incrementing to the next. I don't know databases well enough to
program this. Any ideas? Thanks!
I have a table "InvoicesToBePaid". It contains a list of clients with
invoices that need to be paid based on terms. The records were appeneded to
this table with a query that computed and appeneded a pay date to a field.
Now I don't want to issue a separate check for each invoice when a client
has mulitple invoices that pay the same day. I have a custom report that
prints to my check stock that groups them by client so one check can pay
multiple invoices for the same client..
The Check number is on my check stock. I want to somehow enter the starting
number, of the check numbers, for instance 100. After the checks print, a
query must update each record with the appropriate check number, but it must
mark them in sequence (autonumber from my starting point), and mark the
invoices that were paid together on one check all with the same check number
before incrementing to the next. I don't know databases well enough to
program this. Any ideas? Thanks!