Syntax problem

[Mikey]

On the second WHERE the data must be greater then "0". Can't get the systax right.

strQuery = "SELECT * FROM Pizzo "
strQuery = strQuery & "WHERE DateofDay BETWEEN "
strQuery = strQuery & "#" & varStart & "# And #" & varEnd & "#" and WHERE (Chiller1Amps <> 0) "
strQuery = strQuery & "ORDER BY DateofDay, TimeofDay ASC "

[Wydok]

You only need the keyword "WHERE" at the beginning of your where clause:

strQuery = "SELECT * FROM Pizzo " & _ 
                     "WHERE DateofDay BETWEEN ("  & _
                     "#" & varStart & "# And #" & varEnd & "#)" & _
                     " AND Chiller1Amps > 0 " & _
                     "ORDER BY DateofDay, TimeofDay ASC "

[Mikey]

OK Thannks I'll try it.