DCount Syntax

[nasa09]

I'm having a bit of trouble with the syntax for DCount, and I was hoping that someone could set me straight.

I have a query called qry_recons, and I'm trying to count all of the results of the query that have a value of "ML" in the field LOAN_TYPE and that have a value of "Y" in the field WITHIN_30.

What would be the proper syntax? I've tried a few different things and nothing has worked so far, but I know that this must a really simple thing for the pros.

I appreciate any help that you guys can provide!

 

[pbaldy]

See if this gets you started:

http://www.mvps.org/access/general/gen0018.htm

 

[plog]

You usually don't use aggregate domain functions (DCount, DMax, DSum, etc) in queries. Instead, you would use a query itself:

SELECT COUNT(LOAN_TYPE) AS RecordCount
FROM qry_recons
WHERE LOAN_TYPE="ML";

 

[nasa09]

Thanks, Paul. That's helpful.

And Plog, I probably should have been more clear...I'm actually not using DCount in a query (I'm using it in a report), but I posted in this forum because it was related to queries. I guess in retrospect I should have posted to Reports.

 

[pbaldy]

Happy to help!