Hello All, I run a query and get a set of records. Those records from query, I want to use for criteria to delete records from a particular table. Any help.

hi, I have a table in which there appears to be duplicate and redundant records. Can anyone tell me how I would write a delete wuery to delete those...

Ok gurus I need your help, I am new to sql and access database, so easy on me, here is my need: I have a table named table1234, within this table I have a...

I currently have a list of data and have found Serial ID's with related problems on different dates. What I need to do is list all the Serial ID's and delete...

Hi, I'm trying to create an archive table here. I have managed to copy those closed transaction to another table, but now I'm having problem to delete it from...

Hi, When i do a delete query, after a message box ( you are about to delete 2 rows from the specific table.../) then i click yes. after that another message...

I have a table that has 20 fields and might contain duplicate information based on 3 fields(ID, LoanNum, date). How do I create a delete query that would...

I have created a table in access which is has three columns, one is Name, which refer to the name of person making the order (duplcates allowed), one is...

Unfortunetly I was unable to apply the solutions from other who had similar problems: Basically, I have delete query (SQL below) which is generating the...

I have the following query which i like to convert into a delete query and use the command Dim StrDelete As String DoCmd.RunSQL StrDelete Can you help me ? My...

hi, I have the following: DELETE * FROM tbl_masterpop_main WHERE in (SELECT DISTINCT Tbl_archive., Tbl_archive.pasted, Tbl_archive.PopEnterDt FROM...

I have a small app to print out multiple reports. The user inputs the data on the form, which writes to the table. Then the user can choose which reports are...

I was wondering how this would be done. Currently I have a database set up tracking employees and all kinds of training, disciplinary, errors, etc. They are...

This is posting I have posted in many new newsgroups. And after many responses saying I can't do it. I would like a way around what I'm trying to do...

How do I write a query that will delete all rows in a table where the date column is greater than 30 days old? Thanks in advance! Tom

I have a table that has duplicate records. I use a find duplicate query to find the duplicate records. I use "Customer ID" field to find the duplicate...

Hello All, I have a SS#, Last, First, Source, Dept, ZipCode table. I noticed I have duplicate people. e.g. ss last first source dept ...

Hi, I am trying to delete records from one table where they appear in another, I have joined the 2 tables see code below -: DELETE Inspection.* FROM...

Here's the problem. I have 2 tables. Table A Account Number Desc Name Table B Account Number Desc Name I need to delete the record in Table...

Hi, Why the below query doesn't work? I have been in the situation that I need to delete some records by using the query below. Access doesn't allow me to...