hi,
this is a bit strange
we have two separate systems - one for accounting (accpac plus), one for invoicing (vb6/access2000) - they are not "connected" together.
i want to print a letter to customers with outstanding balance. payment status (paid/outstanding) is only available in accounting system, but for certain/practical reasons i want to print it from invoicing system.
i can get all invoices for certain customer, but i have to manually select unpaid invoices and use them as input data for report/letter.
my recordset looks like this:
INVOICE DATE CUSTOMER CUSTORD
139 10/06/05 LUMBER LTD. 7455
140 10/06/05 LUMBER LTD. 7463
201 10/31/05 LUMBER LTD. 7555
253 11/01/05 LUMBER LTD. 7455
i am thinking about adding one column "SELECT", manually select outstanding invoices and then create report using marked records.
the problem is how to add new column to a recordset, select records and use it for report. any ideas, please?
this is a bit strange
we have two separate systems - one for accounting (accpac plus), one for invoicing (vb6/access2000) - they are not "connected" together.
i want to print a letter to customers with outstanding balance. payment status (paid/outstanding) is only available in accounting system, but for certain/practical reasons i want to print it from invoicing system.
i can get all invoices for certain customer, but i have to manually select unpaid invoices and use them as input data for report/letter.
my recordset looks like this:
INVOICE DATE CUSTOMER CUSTORD
139 10/06/05 LUMBER LTD. 7455
140 10/06/05 LUMBER LTD. 7463
201 10/31/05 LUMBER LTD. 7555
253 11/01/05 LUMBER LTD. 7455
i am thinking about adding one column "SELECT", manually select outstanding invoices and then create report using marked records.
the problem is how to add new column to a recordset, select records and use it for report. any ideas, please?