DCount using Multiple Criteria

WKI Published at Dev

19

WKI

I am not sure why my code does not return the right number of records. I have:

counter = DCount("*", "tbl1", "[Check] = FALSE OR DateDiff('d', [CheckDate], 
Date()) > 365 And [Room] = '" & Forms!frmSelect.txbSelect.Value & "'")
checkIndicator.Caption = "(" & counter & ")" & " available!"

It seems that the part with [Check] = FALSE OR DateDiff('d', [CheckDate], Date()) > 365 works fine but the the entire code is not. Thanks in advance!

Lee Mac

Your current code will return a count of records in tbl1 for which:

[Check] = FALSE (for any value of [Room])

OR

DateDiff('d', [CheckDate], Date()) > 365 AND [Room] = Forms!frmSelect.txbSelect.Value

Depending on the desired result, I'm guessing that you require [Room] = Forms!frmSelect.txbSelect.Value to always be true, and so the logic should be enclosed with parentheses in the following way:

"([Check] = FALSE OR DateDiff('d', [CheckDate], Date()) > 365) And [Room] = '" & Forms!frmSelect.txbSelect.Value & "'"
 ^                                                           ^
 |                                                           |
 +----------------- Added parentheses here ------------------+

This is now returning the count of records in tbl1 for which:

[Room] = Forms!frmSelect.txbSelect.Value

AND

[Check] = FALSE OR DateDiff('d', [CheckDate], Date()) > 365

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-05-21

Comments

0 comments

Login to comment

Related

Using multiple criteria to find a WebElement in Selenium

How to sort an ArrayList using multiple sorting criteria?

Update multiple rows using hibernate Criteria

Masking a DataFrame using multiple criteria

VBA Autofilter Using Multiple Criteria

AVERAGE using multiple criteria from multiple columns

Search using multiple criteria in excel

Oracle - Unique ID fetch using multiple criteria

Using Filter Formula with Multiple Criteria and Allowing Blank Criteria

Multiple Values using single Criteria

Why is my date criteria filtering incorrectly in a MsysObjects query using DCount?

How do I use DCount with criteria on a Recordset?

DCount using two Criteria

'Tagging' a record using multiple criteria

using find and replace for multiple string criteria in R

Logrotate: Using multiple criteria for rotating

LINQ Group By using multiple criteria

Search using multiple criteria

DCOUNT With Function in Criteria

Using FILTER Function With Multiple Criteria

Returning multiple values using multiple matching criteria

Using .loc with multiple selection criteria

Using multiple criteria for one IFS criteria

countif unique values using multiple criteria

Using Countifs to count distinct values and multiple criteria?

Using a textbox with multiple criteria to search multiple fields

Dcount function using parameters

Dropping rows using multiple criteria

AutoFilter with multiple criteria using dictionary

TOP Ranking

Article

HotTag

Archive