Dcount syntax: between two user defined dates

[mvorous]

The following is what I'm trying, but it throws an #Error, =DCount("*","[BFReceivedChrysalis]","[orderdate] between [txtStartDate] and [txtEndDate]"). Hope it is simple...

 

[pbaldy]

This should help:

http://www.mvps.org/access/general/gen0018.htm

 

[mvorous]

My problem is with the exact syntax "Between" two user defined fields. I tried to deduce from the example, to no avail. Thx

 

[mvorous]

Solution: Re: Dcount syntax: between two user defined dates

=DCount("*","[BFReceivedChrysalis]","[orderdate] between [txtendDate] And [txtStartDate]")