Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Syntax error (Access 2000)

    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)"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Syntax error (Access 2000)

    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).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •