Can you delete a record in a query without deleting the record in the table?

Hi, I'm working on a table which contains a colume with strings with different length. some of the strings has "0" before them and I need to delete the "0"....

I have data like this in my table: *NE7353 * NE7928 **SNE800877 *HW30146** I want a query that removes the * from the data. Thanks

I have a table with 66,180 mailing addresses and I did the duplicate query and it found 3288 duplicates. I tried to do the delete query to delete the...

hi all How can we delete a file using MS Access commands? -- Message posted via http://www.accessmonster.com

I need to delete all records in a query where all records have a description that starts with an "L". But I don't know how to put that into the criteria box....

I've opened a Query with the following commands: ******************************************* Set Wsp = DBEngine.Workspaces(0) Set Dbs = CurrentDb Set...

is there a way to delete a duplicate record in a table for example acct# Name 12434 Smith, John 12434 Smith, John 12222 Frank,...

Hi Groupies I have a table that keeps track of all of my employee transactions (tblCampCosts). In one day the same employee may have many transactions that...

I want to delete all but one of the records that have duplicate values in one field. In query design I have tried setting unique value to yes but that leaves...

I have a D-Base with 6 tables, 3 of which (tables A B C) I want the user to be able to delete all the information in. I want this to be to be done using a...

Is there an easy way to delete all the data in a specific column on a single table? I want the rest on the data in that table to stay the same.

Read many of the threads but seem to be missing what I need to do . . . probably based on my limited access knowledge. I have a query that is based off one...

Here is code I have that deletes all queries, forms, and reports. The last part I want to delete all modules but one. Any ideas? Case 4 is modules, and the...

How can i delete all ole objects from my database I tried update table set field = null but it does not work thanks

Hi and thanks for reading, Working in VBA - this is part of an automated import function... I have two tables Students and Reports. Most students have many...

-- Earl Miles Mitchell Access 2003 Trainee

Hello -- I have a table that list a set of records that I need data for (tblScan) and several tables that contain many more records than I need. How can I...

DELETE * FROM TEMP_IMPORT; Which of course works, but what is the syntax for adding TBL2? Thanks in Advance.

Hi Froum well I want to delete a set of rows from a table by joinin it with another table but I get this error : "Could not delete from specified tables" but...