Help with report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. I have a form called "Projects" with a subform called "Expenses" the projects form is linked with another form called "Customers" so that only the projects belonging to that customer display. In the "Expense" subform I list expenses belonging to that project. I created a Report called "Invoice" there I have a field called Expense description which is suppose to list all of the expenses that belonged to that specific project. Right now in the expense description field I have the code "= Forms![Project]![Expenses].Form![Description] " the problem with that is that it will only show the active expense description but the rest even if they belong to that project don't display in the invoice. How can I make the invoice display all of the expenses that belong to that project?

Thanks.
 
Try a subreport for the expenses. It is done similar to making the subform.

--
Wayne Morgan
Microsoft Access MVP


Hfchavarria said:
Hello. I have a form called "Projects" with a subform called "Expenses"
Click to expand...
the projects form is linked with another form called "Customers" so that
only the projects belonging to that customer display. In the "Expense"
subform I list expenses belonging to that project. I created a Report
called "Invoice" there I have a field called Expense description which is
suppose to list all of the expenses that belonged to that specific project.
Right now in the expense description field I have the code "=
Forms![Project]![Expenses].Form![Description] " the problem with that is
that it will only show the active expense description but the rest even if
they belong to that project don't display in the invoice. How can I make
the invoice display all of the expenses that belong to that project?
 
Back
Top