473,398 Members | 2,335 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

MS Access Question Loop and delete

31
Is there a way to loop thru looking for duplicated values in a table "column1" and look at the next row in column2 for a value and if the value equals BBB then delete the duplicate values.

column1 column2

AAA
AAA
-------------BBB

CCC
CCC
CCC
-------------BBB
Aug 11 '10 #1
0 845

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: P.B. via SQLMonster.com | last post by:
I cannot execute my sql to create a table with ON DELETE CASCADE option. Here is my sql: CREATE TABLE Employees (Name Text(10) not null, Age number, CONSTRAINT pkEmployees PRIMARY KEY (Name)); ...
3
by: oskar hritz | last post by:
It may sound stupid but I have not found any person able to make multiple deleting of objects in Access 2000. I would like for example to delete all queries (I have 200 of them) and download them...
6
by: Oliver | last post by:
Hi there! Does anyone know of a way on how you could access/loop through the variable names. E.g. if you have a struct and want to loop through all variables in that struct to give its value to...
0
by: Holger Marzen | last post by:
I had tomatoes on my eyes. I wrote laufverke but meant laufwerke. Sorry. ---------- Forwarded message ---------- Date: Mon, 12 Jul 2004 15:03:14 +0200 (CEST) From: Holger Marzen...
6
by: bobdydd | last post by:
Access 2000 Windows XP Hi Everybody I have got a weird one here. I have a large form frmTransactions based on a single table tblTransactions. There are a lot of fields on the form but...
7
by: alan_conoco | last post by:
Hi all, I am trying to delete a subset of records (identified using my InsertRemovePairs query) from a table names TradesDone. When I execute the nested SELECT on its own it returns the...
2
kcdoell
by: kcdoell | last post by:
Hello I have a code where I want to delete the records that are found in my DAO recordset. I took a stab at this for the first time and got it to work but it is only delete one record at a time. If...
2
by: bibek24 | last post by:
Hi all, The following problem is occuring for a particular user who doesn't have full permissions to the shared folder. Microsoft Office Access cann't delete the original mdb file after...
1
by: kilabyte | last post by:
I have a csv file that I download from a remote server every morning at 8am. This is imported in access and written to an Access table on one of the servers, having first deleted the previous days...
3
anoble1
by: anoble1 | last post by:
I'm trying to get a process which exports to a report running as a loop 6 times. The last working configuration was: While Not records.EOF For i = 1 To 4 So, I have 1,2,3,4 as you can...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.