i want to filter by date eg. let's say from August 4 to September 4 in
access
No idea what you are asking. Please write complete sentences and explain
what you'd like to do.
The short answer to your question would be...
Between [EnterSartDate] and [EnterEndDate]
Without know where you are trying to use this, I can't give you any further
guidance.

Signature
Rick B
> i want to filter by date eg. let's say from August 4 to September 4 in
> access