I'm trying to find out why this is wrong, while in the queries generator it works properly.
With some dates slightly different It works, but I think that when It does not find any value in this Table, the error appears. No idea if it's a problem of the Query design, or if there is another way to define it, or not. Any clue, anyone?
Thanks in advance!
Code:
SELECT Count(Audi.Id) AS CuentaDeId FROM Audi WHERE (((Len." & filtro & ") Between #" & Format(Me!fechamin, "mm/dd/yyyy") & "# And #" & Format(Me!fechamax, "mm/dd/yyyy") & "#))
With some dates slightly different It works, but I think that when It does not find any value in this Table, the error appears. No idea if it's a problem of the Query design, or if there is another way to define it, or not. Any clue, anyone?
Thanks in advance!