1. Report has been already created. It requires to be improved so , each customer appears into independent page and if invoice takes more than one page then an horizontal line should be added at end of that page and a legend saying " continues on next page". Also is necessary to add page number in a customer basis, I mean if an invoice for Customer A has 3 pages then a counter 1/3,2/3,3/3 should be in place. If Customer B invoice has just 2 pages then counter would be 1/2, 2/2, etc.
2. Create a macro to change automatically [triggered when macro is run] data type of a Table from Text to Date.
REQUIREMENT: ACCESS 2007
PLEASE REFER TO ATTACHMENT TO GET A COMPLETE DOCUMENTATION.