|
-
Dec 2nd, 2002, 04:44 PM
#1
Thread Starter
Hyperactive Member
Syntax problem
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 "
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote