Using "Between" values in a form box

[grussell070769]

I am trying to pull in information using a between factor with dates.

So I want to pull in how many claims an individual works within a weeks timeframe? I am able to get the information by using just one day at a time, but I am sure there is an option to get the between data in once click.

Thanks In Advance

 

[welshgasman]

Use a DCount()

 

[jackd]

Between is inclusive of end points