Variable Citeria

[jennlts]

I have a query that a number of people use and may need information from diffrent date ranges, and customers.

So I set up the date Critera to be: Between [Start Date] and [End Date]
And The Customer Name Critera to be : [Forms]![CustomerListAnalysis]![CustomerName]
It work just fine giving everyone a pop up to enter thier personal prefrence and to take the Customer name entered in the form

But today all of a sudden it asks for the date range twice then returns no data.

Does anyone know what might make these stop working? I have already test all the data and there are record that meet the cirtera entered

 

[SimonB1978]

Hi,

Something similar once happenned to me. I have no explanation why but here is how I "solved" the problem:

-Create a new query.
-Copy the SQL expression of the "broken" query to the new one.
-Rename things accordingly.

If that doesn't help then I have no idea...

Simon B.

 

[jennlts]

Thank you that seems to have fixed the problem