What does " < #" do? (1 Viewer)

Sketchin · Feb 21, 2018

I have a criteria in a DCount that says "MinOfDateout < #" and have no idea what < # is doing.

MinOfDateout is a field in a query.

The entire string looks like this:

Code:

UNICompaniesSupportedCumulativeAB = Nz(ECount("[MaxOfContactID]", "QryCumulativeMetricsNew", "[State/Province] = 14 AND [CompanySizeID] = 5" & " and MinOfDateout < #" & [Forms]![frmdashboard]![txtDateTo] & "#", True))

plog · Feb 21, 2018

You actually have an ECount call--perhaps its a typo. The < # are two different symbols, doing two different things:

< is the less than comparison operator.
# is the date escape character, it lets the computer know that what comes next is a date

Lastly, you don't need a NZ around a DCount--its going to return something therefore the NZ will never trigger.

Sketchin · Feb 21, 2018

Geez, I am out of practice.... Now I see how # is being used, it is saying that everything between the #'s is a date.

#" & [Forms]![frmdashboard]![txtDateTo] & "#

It's been a VERY long time since I have actively developed! Thanks for the help.

Mark_ · Feb 21, 2018

@Plog,

It is something from Allen Browne's site.
http://allenbrowne.com/ser-66.html

What does " < #" do? (1 Viewer)

Sketchin

Registered User.

plog

Banishment Pending

Sketchin

Registered User.

Mark_

Longboard on the internet

Similar threads

Users who are viewing this thread