DCount in Report

R

ravi

You could create a query and have a calculated field in
there.
primExpr1: iif(Primary=yes,1,0)

save this a query1

now base you dcount on the above query

=dcount("primExpr1", "query1")

You could do most of your calculations in the query and it
is better to base your reports on the query add any
sorting required in the query.

good luck
ravi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count or DCount used in a report 1
copy format and formulas of one report to a second report 2
Get Sums for 2 DCount fields on report 1
very slow report with dcount() 6
Summary Report 3
Count Yes/No field in report? 2
Sum DCOUNT Calculated Control 2
Adding values from sub reports in the main report 8

Top