Results 1 to 4 of 4

Thread: Delete query

  1. #1
    Join Date
    Nov 2009
    Posts
    29

    Unanswered: Delete query

    How do I set up the query when they want to delete the records that starts with the word small?

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Add a column to your delete query. In this column for the field enter expr1:Mid([Field Name],1,5) now in the criteria for this column enter "small".

    Field Name is the name of the field that has the text starting with small.

    To check if it works make your query a select query and only records that start with "small" should be displayed. If it works change your query to a delete to delete the records.

  3. #3
    Join Date
    Mar 2009
    Posts
    5,441
    Provided Answers: 14
    DELETE * FROM <Table> WHERE <Column> LIKE "small*"
    Have a nice day!

  4. #4
    Join Date
    Nov 2009
    Posts
    29
    I tried small* and it worked. Thank you soo much. I'm sure I'll be back.

Posting Permissions

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