Dear I need on help on Dcount with multicriteria

[anweraijaz]

I used the following criteria for dcount function but it is not working and giving wrong reply.

=DCount("[eamvu status]","Primary table","[eamvu status]='stage-II awaited' And [purchase order date]=year(now())")

Hoping for intime response

Anwer Aijaz

[twinnyfo]

anweraijaz,

Welcome to Bytes!

First, please use Code Tags when posting any code or SQL statements.

Second, if I look closely at your criteria of the DCount function, I see this:

And [purchase order date]=year(now())

I can only assume that the purchase date is a full date (for example, 2018-03-05), but you are checking to see if it equals a year (for example 2018), not to mention that your sytax is a bit off. This will not produce the results you want.

One method that might work (if you know you are always checking for purchase orders that have occurred within the current year) is this:

And [purchase order date] >= #" & Year(Now()) & "-01-01#"

Let me know if this hepps out at all