Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Location
    Shropshire, UK.
    Posts
    25

    Unhappy Unanswered: Whats wrong with this delete query?

    DELETE FROM OnlineUsers WHERE (OnlineUsers.LastKnownRequest) < (CDate("9/5/2002 10:48:54 PM"))

    I get 'Error - Too few parameters. Expected 1'

    Any clues?

    TIA

    Mark.
    Mark Wills.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Which version of access are you using ? How are you deleting the record (dao/ado) ?

  3. #3
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    Try:

    DELETE FROM OnlineUsers WHERE (OnlineUsers.LastKnownRequest) < (#9/5/2002 10:48:54 PM#))

    Is there a particular reason for using CDate()?

    Dan

Posting Permissions

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