JSz. wrote:
I have edited the query in SQL view and I have manually changed the
formulae:
"EndReading"."Odometer" - "Fuel"."Odometer" = '>=0'
"EndReading"."FuelID" - "Fuel"."FuelID" = '1'
into:
"EndReading"."Odometer" - "Fuel"."Odometer" >=0
"EndReading"."FuelID" - "Fuel"."FuelID" = 1
and saved the query.
Now it works well.
Jacek Szymona
The Query Design dialog can introduce the problem you noticed:
'>=0' and = '1'. While working to solve your problem, I opened the Query
Design dialog several times. I specifically entered =1, but after a few
close and open sequences, it became ='1'.
The query will work just as well with >0 rather than >=0.
--Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
