Syntax error (Access 2000)

Topic

New Reply

How can i delete calls higher than 30000 and less than 400000 ? Te line below gives me a syntax error
sql = ” DELETE CallsClients.*, CallsClients.Callid FROM CallsClients WHERE ((CallsClients.CallID) > 300000 and < 400000)"

Reply | Quote

Replies

Either use

… WHERE CallsClients.CallID > 300000 AND CallsClients.CallID < 400000"

or

… WHERE CallsClients.CallID Between 300001 And 399999"

(If you use Between … And …, the lower and upper bound are included, so you must use 300001 and 399999 instead of 300000 and 400000).

Reply | Quote