Query from date to date

[sonya]

i have a query that I am working on to where I want it to Show me orders from , lets say 11/27/02 to 12/02/02. It tells me to give it a begining and ending date but it gives me no info
Can someone help me figure this out

 

[BLeslie88]

Sonya...

Can you please show us your condition clause so we can view the problem?

Regards,

 

[Autoeng]

First, remove the criteria (Between start date and end date" from the query to make sure it is returning something. If not you have lost its reference data. Recreate the query making sure to point it to the correct data source. If it does return ALL of you data then make sure the critieria "Between start date and end date" must be under the query field for the date.

If neither of these work post back with as much detail as you can and we'll try to work through it.

Autoeng