Dcount in a Form with multiple And plus Date and Time

[Clexidr@]

Hello,
I have a problem with this DCount expression that I put in a textbox into a form.

I receive the "Error" message but I don't understand why (please note my windows is setup for Italian language and ";" is correct.

=DCount("[ID_Orders]";"[tbl_tmp_period]";"[Orderexit]='Order_Inbound' And [start order] Between #02/01/2017 00:00:00# And #02/28/2017 23:59:59# And [Time]='>#00:00:00# And <=#00:00:10#'")



Thanks in advance.

[pbaldy]

Two problems. You don't want the single quotes (apostrophes) around the time criteria. For the time criteria, you need to repeat the field name since you didn't use Between:

[Time]=>#00:00:00# And [Time] <=#00:00:10#