Help with report

[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.

 

[Wayne Morgan]

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

--
Wayne Morgan
Microsoft Access MVP

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?