DCOUNT issue (where value is one of 2 characters)

[chris-uk-lad]

Hi,

Im trying to ammend this, will be simple i know but my sum isnt working. I want the following count to ALSO include values where Status = B.

=DCount("[Ref_No]","Old","[Status]='A'")

I tried
=DCount("[Ref_No]","New","[Status]='A' " AND "[Status ='B']") but shows a number that doesnt add together

Any ideas?
Thanks

 

[Rabbie]

=DCount("[Ref_No]","New","[Status]='A' " AND "[Status ='B']") can never work because Status can never be 'A' and 'B' at the same time

Try

=DCount("[Ref_No]","New","[Status]='A' OR [Status ='B']")

 

[chris-uk-lad]

tried what u suggested but only gave '#Error'. Just to emphaisise, i want to get a total number of Ref nos where status is A or B.

 

[Rabbie]

Then try
=DCount("[Ref_No]","New","[Status]='A'" OR " [Status ='B']")

 

[chris-uk-lad]

Nevermind iyou had it right the first time, just a square bracket on B was meant to be after status

=DCount("[Ref_No]","New","[Status]='A' OR [Status] ='B'")

 

[Rabbie]

Nevermind iyou had it right the first time, just a square bracket on B was meant to be after status

=DCount("[Ref_No]","New","[Status]='A' OR [Status] ='B'")

Glad you got it working. Thanks for posting the correction

 

[chris-uk-lad]

Hi, I have a formula to work with where as i want it to return the number of records that dont have the following Status entries.

=DCount("[Ref_No]","New","[Status]not in ('A','B','C','D' )")

However, i want it to then be left with fields where [Status] is ' ' i.e empty, nothing inside. It doesnt seem to pick up on an empty cell though.

Any idea why? and a resolution?