Query date field on the fly 1

[netrusher]

I have a query that I want to base on a date range. When the query is ran I want to be able to enter the date range at that time. I have:

[Enter Date:] in the Criteria Field but if I enter Between or < or > an error comes up saying the expression is wrong or to complicate to evaluate.

Can anyone tell me how to run a query and input the dates wanted on the fly.

Thanks in advance.

Allen

 

[Remou]

You would say:

< [Enter Date: ]
Or
> [Enter Date: ]
Or
Between [Enter Start Date: ] And [Enter End Date: ]

Or better still, you would use a form.

 

[ddiamond]

Allen,

Can you post the SQL that is giving you that error message?

- Dan

 

[netrusher]

Thanks guys, It is work with the Start and End dates.

I appreciate your help.