Help with an Expression

[amandajaynemc]

I am having trouble building an expression. Please help.

In my query I want to use an expression in the "next contact date" field. Each time I run the query I want to input the beginning date and end date. This will hopefully return all the records between ie. 2/02/04 - 06/02/04.

I know there is an expression to do this as I have used it previously but cannot remember what it is!

Thank you.

 

[Ally]

In the criteria row of "Next Contact Date" field put:

Between [Enter Start Date] and [Enter End Date]

This will give you parameters when the query is run. Ensure that the dates are entered in the same format as they've been entered.

 

[Mile-O]

Put Between [Enter Start Date] And [Enter End Date] in the criteria.

There are better, neater ways to perform this though.

 

[Rich]

Since you can't validate the entered dates you'd be better off passing the parameters via a form.