Dcount and between

[Clexidr@]

Hello,

I input this in a text box in a form but I receive an "error" message:
=DCount("[ID_Orders]";"Orders";"[Due Date] Between #01/02/2017# And #28/02/2017#")

Can you help me ?

Thanks.

[CJ_London]

usual convention is to use comma's rather than semi colons, but some languages do use semi colons instead.

=DCount("[ID_Orders]","Orders","[Due Date] Between #01/02/2017# And #28/02/2017#")

also your dates need to be in US format of mm/dd/yyyy

your code as written will provide count of records between 2nd Jan and 28th Feb (Access is bright enough to see the 28 is not in the range 1 to 12, so assumes this is in the format dd/mm/yyyy)

other things that can cause an error - you don't have a table called Orders and/or you don't have fields called ID_Orders and Due Date

[Clexidr@]

Thanks, indeed I had a problem with the data format.