Count totals from seperate queries in one report

  • Thread starter Thread starter Eklund
  • Start date Start date
E

Eklund

Hello,
I have a report that calculates "open" items from an "open
items" query. On the same report I would like to include
the total quantity of items from the query that includes
all times. This part does not work.

=Count([Spec Section #]) *This works*

=Count([OCPAC Current Submittals]![Spec Section #])
*this doesn't work*

any ideas...?

Thanks
 
A report can only have a single record source. You can add subreports based
on other record sources. We don't know how you calculate "open" items. Is
the report's record source "[OCPAC Current Submittals]"?
 
I have a submittal Table and two queries 1) OCPAC Current
Submittals, 2) Open Submittals. I was able to get the sum
of the open submittals, but was trying to pull in the sum
of all submittals from the OCPAC Current Submittals
query. I'll try it with the recommended Sub Report, or
use the Current Submittals and play with the criteria to
get the count of the open submittals.

Thanks.

-----Original Message-----
A report can only have a single record source. You can add subreports based
on other record sources. We don't know how you calculate "open" items. Is
the report's record source "[OCPAC Current Submittals]"?

--
Duane Hookom
MS Access MVP


Hello,
I have a report that calculates "open" items from an "open
items" query. On the same report I would like to include
the total quantity of items from the query that includes
all times. This part does not work.

=Count([Spec Section #]) *This works*

=Count([OCPAC Current Submittals]![Spec Section #])
*this doesn't work*

any ideas...?

Thanks
Click to expand...


.
Click to expand...
 
You can also create one "master" query which includes the fields from both querys that you want reflected in the report - then run your report based on the "master query".
 
Back
Top