P
pgarcia
Hello all,
I hope I can express what I need correctly as I am a novas to Access.
I have around 2910 lines of data. The data is blocks of invoices for that
day. The invoice number do not repeat, however, the account name, address etc
do repeated. I need to create a form that will allow me or my user to print
out statement invoice for that day. The header would be the account name,
address and account number. The detail would only pick up line items with the
same account number on that page (or if it runs long, 2-3+ pages.
E.g. Company A has 5 invoices, company B has 12 and company C has 2. So I
would need only three invoice statements printed, but they should have all
the data of the invoice (Origin, Destination, Reference No (1, 2, 3), Invoice
number, date and amount.
I have created a form but it does not separate the accounts, it runs
together. The header does change but the page contains information from the
next account or previous account.
Thanks
I hope I can express what I need correctly as I am a novas to Access.
I have around 2910 lines of data. The data is blocks of invoices for that
day. The invoice number do not repeat, however, the account name, address etc
do repeated. I need to create a form that will allow me or my user to print
out statement invoice for that day. The header would be the account name,
address and account number. The detail would only pick up line items with the
same account number on that page (or if it runs long, 2-3+ pages.
E.g. Company A has 5 invoices, company B has 12 and company C has 2. So I
would need only three invoice statements printed, but they should have all
the data of the invoice (Origin, Destination, Reference No (1, 2, 3), Invoice
number, date and amount.
I have created a form but it does not separate the accounts, it runs
together. The header does change but the page contains information from the
next account or previous account.
Thanks