B
Baine
I am trying to generate an invoice from the data in the tables I have setup.
Tables: Projects, Customers, Employees, Hours, and Expenses. I created one
query for the projects and a sub-form for the hours. I created a new report
called Invoice. I dragged the query and the form to the report. The report
looks great. I added a field at the bottom of the sub-report to sum the
hours worked field. That also worked. One thing that is happening is when
I open the report a box opens asking for the parameter value of the
customerID. When the projects are entered into the database the CustomerID
is used. It is linked to the CostomerID field in the Customer table. Also
when I step through the records of the invoices it displays a blank page for
the second record and then displays the first invoice again for third
record. It keeps showing the two pages described here until I get to record
nine. It then shows the second invoice.
Should I be using a form with two querys for the invoice?
Should I be using a report with two querys for the invoice?
My son's small company with less than 500 invoices a year.
Using Access 2002
Tables: Projects, Customers, Employees, Hours, and Expenses. I created one
query for the projects and a sub-form for the hours. I created a new report
called Invoice. I dragged the query and the form to the report. The report
looks great. I added a field at the bottom of the sub-report to sum the
hours worked field. That also worked. One thing that is happening is when
I open the report a box opens asking for the parameter value of the
customerID. When the projects are entered into the database the CustomerID
is used. It is linked to the CostomerID field in the Customer table. Also
when I step through the records of the invoices it displays a blank page for
the second record and then displays the first invoice again for third
record. It keeps showing the two pages described here until I get to record
nine. It then shows the second invoice.
Should I be using a form with two querys for the invoice?
Should I be using a report with two querys for the invoice?
My son's small company with less than 500 invoices a year.
Using Access 2002