Using DCount with an expression 2

[ray436]

I am probably doing this the hard way, but what I need is a total on my report that shows the number of occurances of either "found" or "closed" from the "status" field in a query that produces a list of records that have either "found" or "closed" in them for a particular client.

The query does isolate the client, but the total I end up with applies to all records in the table.

this is what I have in the control property:

=DCount("[MASTER DATABASE]![status]","[MASTER DATABASE]","[status]='FOUND'&quot

I need to qualify the "status" field to be only the records that match the "client" field that the query is using.

I tried this, but no good:

=DCount("[MASTER DATABASE]![status]","[MASTER DATABASE]","[status]='FOUND'& [client]='whoever'&quot

Is there a better way?

Thanks!!

Ray

 

[Rohdem]

Try these:

=DCount("status","MASTER DATABASE","status = 'FOUND' AND client = 'whoever'&quot

OR

=DCount("status","MASTER DATABASE","status = 'FOUND' AND client = ' & me.clientbox & "'&quot



Mike Rohde
rohdem@marshallengines.com

 

[ray436]

Now were talkin'

thanks Mike, it was a day when the longer you look the more confused you get!

Like what you have, and it works too! What I found also works was to name the Query "getFound", (the query that the report is based on), in the expression like so:

=DCount("status","getFound","status='FOUND'&quot

I didn't realize that the name of the query could be used in the argument. Now I can just change the query and it ripples through to the report.

Thanks again!

Ray