View Single Post
  #2  
Old May 19th, 2010, 12:29 PM posted to microsoft.public.access.reports
xps35
external usenet poster
 
Posts: 22
Default Creating a printed report containing multiple counts

jim_s via AccessMonster.com wrote:


Hi All,

Been trawling around for a solution to this problem. The problem is pretty
straightforward, yet surprisingly complicated to solve.

I have a statistical report that needs creating when demanded by the user.
The user enters a date range on the form in 2 text boxes and the values are
passed into queries(?). The stats report should then contain a load of count
statistics for how many records have been received/rejected/exported etc. in
that date range. The counts also have different conditions - imported records
for instance need to fit the date range entered by the user, but for the
exported records section of the report, records' export date needs to fit the
date range specified.

Using dCount on the report itself has proved useless. I have copied syntax
from other posts talking about dCount and copied code from Microsoft's own
website and Access doesn't like it. So, is there any way of getting these
counts without running about 40 queries and a load of queries based upon the
queries to get the counts?

Thanks in advance to anyone that helps!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201005/1


I don't see any reason (yet?) why DCounts won't work.

Without knowing your DCounts it is impossible to tell what is wrong.

--
Groeten,

Peter
http://access.xps350.com