Counting records with in a range of a feild

[breeden.christopher]

I'm having problems trying to automate the count of records that have
a date in a feild that lies between the range of txtStartDate and
txtEndDate. Any tips or suggestions?

 

[Guest]

Try this ---
SELECT Count(MonthlyKeylock.KeyDate) AS CountOfKeyDate
FROM MonthlyKeylock
WHERE (((MonthlyKeylock.KeyDate) Between #4/1/2007# And #5/10/2007#));