Form/queries to produce a report

D

DL

Access2K, I use this extensively in my bus.but have never managed to
simplify report production process;
Currently I have to run a series of processes to produce/finalise an invoice
i.e.
I have a report form with a series of btns
1) Itemised invoice
runs a query,from SalesTbl, requiring input of ClientID, TaxDate,DateTo (the
date I'm invoicing to)
This produces a preview report. Once seen as ok, is printed
2) Invoice Totals
runs an update query to the InvoiceTbl - appends various subtotals
requires same details as per Itemised Invoice i.e. ClientID,TaxDate,DateTo
3) Invoice Form
Opens the InvoiceTbl where I have to manually enter ClientID as I've never
managed to get the previous query to append this.
4) Append Invoice
runs an update query on SalesTbl requires same details as before,
ClientID,TaxDate,DateTo, plus Invoice# (From InvoiceTbl record#) appends
Invoice# to SalesTbl for the jobs invoiced
5) Update Lock
Runs an update query on SalesTbl, requires Invoice#, updates a yes/no field
(locks the record for a form view)
6) Statement
Runs a query from SalesTbl + others, requires Invoice# which produces a
preview report, if ok printed

Sorry to be so longwinded, but simplifying this has taxed me, and I really
ought to try. Perhaps someone could offer some guidance.
Thanks
 
Top