G
Guest
Now that I've created my tables and forms to record the data, I'm trying to
build a report to view some information, and also some summary figures about
that information. But I'm running into problems.
First, I made a query pulling the fields I need to display from the various
tables. Then I designed a report around this query, using the wizard and then
modifying the design as needed.
The problem(and there may be multiple problems) is that when I view the
report, it repeats a project over and over again based on the number of
payments or accomplishments that project has. So, if I made 2 payments for 1
project, when I look at the report, it repeats that project 2 times to show
those payments.
How do you set up a report to show the multiple payments, or multiple
accomplishments without repeating the entire project multiple times? Because
in the end I want to be able to total the payments, and total the
accomplishments, to create summaries of the amount spent and the work
accomplished?
Thanks for any advice in advance.
-Justin
build a report to view some information, and also some summary figures about
that information. But I'm running into problems.
First, I made a query pulling the fields I need to display from the various
tables. Then I designed a report around this query, using the wizard and then
modifying the design as needed.
The problem(and there may be multiple problems) is that when I view the
report, it repeats a project over and over again based on the number of
payments or accomplishments that project has. So, if I made 2 payments for 1
project, when I look at the report, it repeats that project 2 times to show
those payments.
How do you set up a report to show the multiple payments, or multiple
accomplishments without repeating the entire project multiple times? Because
in the end I want to be able to total the payments, and total the
accomplishments, to create summaries of the amount spent and the work
accomplished?
Thanks for any advice in advance.
-Justin