Results 1 to 4 of 4
  1. #1
    Zekii61 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2013
    Location
    USA
    Posts
    8

    Angry * deleting multiple rows from a table * help!!!

    Ok, so the assignment is to delete rows in a table that consist of employee ids 202 - 205



    I input the following code:


    delete from sec0412_foods
    where employee_id between '202'
    and '205';



    And then I come across this error:


    Click image for larger version. 

Name:	delete rows.png 
Views:	9 
Size:	76.8 KB 
ID:	13987




    Where am I making a mistake? I am just a beginner and I'm bleeding out my nose here trying to force my brain to get it but no!

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Code:
    Delete sec0412_foods.employee_id
    FROM sec0412_foods
    WHERE (((sec0412_foods.employee_id) Between "202" and "205"));
    Look here to make sure you understand the syntax for delete queries.

    http://www.w3schools.com/sql/sql_delete.asp

  3. #3
    Zekii61 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2013
    Location
    USA
    Posts
    8
    I've tried your code but im still getting the parameter box popping up..

  4. #4
    Zekii61 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2013
    Location
    USA
    Posts
    8
    Hey, btw it's fine you don't need to do anything I've found my way through it

    The code has to look like this

    delete *
    fromsec0412_employees
    where employee_idbetween 202 and 205;

    Thank you again !


Please reply to this thread with any new information or opinions.

Similar Threads

  1. Copy paste multiple rows in a table
    By Biologybook in forum Access
    Replies: 9
    Last Post: 04-07-2014, 02:08 PM
  2. Deleting rows deletes all columns in my report
    By Access_Novice in forum Reports
    Replies: 3
    Last Post: 09-19-2013, 06:15 PM
  3. Replies: 1
    Last Post: 11-20-2012, 03:31 AM
  4. Deleting rows
    By ads8525 in forum Access
    Replies: 13
    Last Post: 02-10-2012, 08:52 AM
  5. Replies: 11
    Last Post: 12-14-2010, 01:25 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums