DCount Help 2

[Herdrich]

Ok im trying to DCount using two different variables. I can use =DCount("Type", "All Query") and that works for all types fine but am trying to use something like =DCount("Type" = "Escorted" And "DateOut" = Date(), "All Query") So that i can specify the type of escorted and records that also match the current date. Any suggestions?

 

[MajP]

Take a look at the help file it provides a good example.

 

[Herdrich]

So far with that this works

=DCount("*","All Query","[Type] = 'Escorted'")

But this does not

= DCount("*", "All Query", "[TimeOut] = Now")
or
= DCount("*", "All Query", "[TimeOut] = Date()")

It only reads out 0 is this because im using the Now date and that includes time so its not matching?

 

[MajP]

you would need to have your functions outside your "". If not you just get the literal string. Something like

"TimeOut = " & Int(date())

If you take the int of date you get the value of the day without time.

 

[dhookom]

I think MajP meant:

=DCount("*","All Query","[Type] = 'Escorted' AND INT(TimeOut) = Date()")

Duane
Hook'D on Access
MS Access MVP

 

[Herdrich]

Still not working for me . In my table im using the Now date format to set the date so I have date and time. I have even tried changing a few of them to the normal 10/11/2010 and ran the DCount as = DCount("*", "All Query", "TimeOut = " & Int(date())) With no luck. Is that correct or is there something different i should be using?

 

[Herdrich]

Sweet that works thank you!

 

[MajP]

Thanks Duane, sometimes I get backwards things around, I mean things around backwards.