Sum and Count for 2 separate pairs of information in 1 report

[Guest]

I really appreciate your answer in advance.
Background: 2 tables (proposal list and project list)
I would like to create a report every month which contain
1. Count of how many proposals were sent in a specific month
2. The sum of dollar amount being proposed

3. Count of how many projects were started in a specific month
4. The sum of dollar amount of the projects

I've been trying to create from the report wizard but it seems like the
system always try to connect the information in the proposal and project
while they are not always related and I purposely want to have them separate
except that they need to be in the same report.

Once again thank you and I really appreciate it.

 

[Jeff Boyce]

If you wish to have two (or more) sets of data reported in the same report,
take a look at using a main report/subreport design.

Regards

Jeff Boyce
<Office/Access MVP>

 

[John Vinson]

I really appreciate your answer in advance.
Background: 2 tables (proposal list and project list)
I would like to create a report every month which contain
1. Count of how many proposals were sent in a specific month
2. The sum of dollar amount being proposed

3. Count of how many projects were started in a specific month
4. The sum of dollar amount of the projects

I've been trying to create from the report wizard but it seems like the
system always try to connect the information in the proposal and project
while they are not always related and I purposely want to have them separate
except that they need to be in the same report.

Once again thank you and I really appreciate it.

One way you can do this is to create the two individual reports; then
create a third unbound (no table, no query) report, and drag the two
reports onto it as independent Subreports. They'll remain completely
independent.

John W. Vinson[MVP]