|
|
Delete Query by
Lamar
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.
|
|
1 |
120 |
|
|
delete query by
geebee
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...
|
|
1 |
68 |
|
|
DELETE QUERY by
guaro555 via AccessMonster.com
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...
|
|
4 |
126 |
|
|
Delete Query by
Matt Dawson
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...
|
|
3 |
60 |
|
|
Delete Query by
enywu
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...
|
|
2 |
47 |
|
|
Delete query by
tspies85 via AccessMonster.com
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...
|
September 25th, 2006 03:03 AM
by tina
|
1 |
79 |
|
|
Delete query by
JOM
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...
|
|
2 |
185 |
|
|
Delete Query by
nir020
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...
|
September 9th, 2008 04:39 PM
by Dale Fye
|
1 |
76 |
|
|
Delete Query by
Bdavis
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...
|
|
2 |
71 |
|
|
Delete query by
peljo via AccessMonster.com
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...
|
|
1 |
136 |
|
|
delete query by
geebee
hi,
I have the following:
DELETE *
FROM tbl_masterpop_main
WHERE in
(SELECT DISTINCT Tbl_archive., Tbl_archive.pasted,
Tbl_archive.PopEnterDt FROM...
|
|
4 |
51 |
|
|
delete query by
jebuss
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...
|
|
4 |
178 |
|
|
Delete Query by
Shanin
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...
( 1 2)
|
|
14 |
1,369 |
|
|
Delete Query by
JeffH13
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...
|
August 24th, 2004 02:29 PM
by JeffH13
|
6 |
387 |
|
|
delete query by
tom
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
|
|
2 |
153 |
|
|
Delete Query by
Lamar
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...
|
|
2 |
98 |
|
|
Delete Query by
mrz via AccessMonster.com
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 ...
|
|
2 |
87 |
|
|
Delete Query by
Phil
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...
|
December 14th, 2005 10:29 AM
by Phil
|
0 |
77 |
|
|
Delete Query by
Bart Bailey
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...
|
January 31st, 2006 09:17 PM
by Bart
|
2 |
126 |
|
|
Delete Query by
Boon
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...
|
June 10th, 2009 09:21 PM
by Boon
|
4 |
94 |