Having searched the archives regarding a Delete Query, I found nothing
specific to my need, although there seems to be a plethora of ideas
and suggestions on queries in general. I have used Delete Queries
based on date selection parameters and those have performed fine, but
perhaps a parameter is not what I should use for the following.
Simply, I need to provide a method by which to query two fields and
delete all records associated with a specific Reference number and
date, i.e., RefID 545, delete all records with RefDate: 2/10/2004.
Well, more exactly, to provide a RefID, that will display all records
grouped by like date and from the selection to choose a group of
records by specific date to delete.
Any suggestions or ideas would be welcomed. Thanks, Dalan 2 1552
DELETE * FROM tblTable1 WHERE tblTable1.RefID =545 And
tblTable1.RefDa te=#2/10/2004#;
This should delete all records that have the RefID 545 and the RefDate
2/10/2004. If the date isn't in US format, you may need to format it in US
format for the query to work properly.
--
Wayne Morgan
Microsoft Access MVP
"Dalan" <ot***@safe-mail.net> wrote in message
news:50******** *************** ***@posting.goo gle.com... Having searched the archives regarding a Delete Query, I found nothing specific to my need, although there seems to be a plethora of ideas and suggestions on queries in general. I have used Delete Queries based on date selection parameters and those have performed fine, but perhaps a parameter is not what I should use for the following.
Simply, I need to provide a method by which to query two fields and delete all records associated with a specific Reference number and date, i.e., RefID 545, delete all records with RefDate: 2/10/2004. Well, more exactly, to provide a RefID, that will display all records grouped by like date and from the selection to choose a group of records by specific date to delete.
Any suggestions or ideas would be welcomed. Thanks, Dalan
Thanks for the suggestion Wayne. I'll give it a go later today,
although I will probably have a couple of follow up questions since
this effort is in part related to a similar companion query. Dalan
"Wayne Morgan" <co************ *************** @hotmail.com> wrote in message news:<XB******* ***********@new ssvr31.news.pro digy.com>... DELETE * FROM tblTable1 WHERE tblTable1.RefID =545 And tblTable1.RefDa te=#2/10/2004#;
This should delete all records that have the RefID 545 and the RefDate 2/10/2004. If the date isn't in US format, you may need to format it in US format for the query to work properly.
-- Wayne Morgan Microsoft Access MVP
"Dalan" <ot***@safe-mail.net> wrote in message news:50******** *************** ***@posting.goo gle.com... Having searched the archives regarding a Delete Query, I found nothing specific to my need, although there seems to be a plethora of ideas and suggestions on queries in general. I have used Delete Queries based on date selection parameters and those have performed fine, but perhaps a parameter is not what I should use for the following.
Simply, I need to provide a method by which to query two fields and delete all records associated with a specific Reference number and date, i.e., RefID 545, delete all records with RefDate: 2/10/2004. Well, more exactly, to provide a RefID, that will display all records grouped by like date and from the selection to choose a group of records by specific date to delete.
Any suggestions or ideas would be welcomed. Thanks, Dalan This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Raj |
last post by:
Hi all,
Can anyone help me with a script which would delete files or
move them to a different folder at some scheduled time..!
Please.....!!!
Thanks in advance...
|
by: The Pig |
last post by:
Got a table.
Date Time Code
1/1/2003 1700 xbc
1/1/2003 1800 xbc
1/1/2003 1800 xbc
2/4/2004 1650 abc
2/4/2004 1700 abc
The problem is I need a query that will delete rows that have the same
|
by: ssb |
last post by:
Hello,
This may be very elementary, but, need help because I am new to access
programming.
(1) Say, I have a column EMPLOYEE_NAME. How do I fetch (maybe, cursor
?) the values one by one and populate a combo box with these names.
(this way, I can display all the EMPLOYEE_NAME values)
(2) In general, can I do additional processing on column values from
|
by: Neil |
last post by:
I am getting time-out errors when I try to perform a simple delete on a
linked server. The command is:
Delete From MyTable Where PKID=12345
I have tried executing this command directly from Query Analyzer, but it
just times out. However, when I run it from QA against the server itself
(rather than from my local server against a linked server), it executes
immediately. Similarly, if I run the same SQL command through an ODBC linked...
|
by: mpar612 |
last post by:
Hi everyone,
I appreciate all of your help with me and the problems I have been
having. I'm new to PHP and MySQL and I'm having some problems getting
this script to work. I can't get this to work and I don't understand
why. I don't get an error or anything, it almost seems like the page
refreshes. I went to the phpmyadmin and the row is still in the
database. The $_GET parts work perfectly in another script and the SQL
statement...
| |
by: tarscher |
last post by:
Hi all,
I have a grid that contains 7 columns from 3 tables (3 unique keys, 4
normal fields). I show this 7 columns on the gridview. I now want to
add edit and delete functionality. This should be fairly easy cos it's
a build in feature of the gridview but alas...
When the user clicks delete only one row on one table needs to be
deleted thus I made a new query in my Datatable (DeleteissueQuery) that
excpects an id
|
by: rn5a |
last post by:
The .NET 2.0 documentation states the following:
When using a DataSet or DataTable in conjunction with a DataAdapter & a
relational data source, use the Delete method of the DataRow to remove
the row. The Delete method marks the row as Deleted in the DataSet or
DataTable but does not remove it. Instead when the DataAdapter
encounters a row marked as Deleted, it executes its DeleteCommand
method to delete the row at the data source. The...
|
by: bluez |
last post by:
I want to design a webpage where user can search the data from the database and list out the related records. Each of the record got a delete button which allow user to delete the record.
Filename : search_student.php
<?php
include("../user_access/user_access_control.php");
include("../Database/database.php");
$searchStudentControl = new Access_user;
|
by: helpwithcode |
last post by:
Hi people,
I am just learning java.I have been creating a project which involves JDBC Connectivity.I find that the statements,
String string_dob=text_dob.getText();
//Converting string to date
System.out.println(string_dob);
s.Info_DOB=Date.valueOf(string_dob);
runs perfectly fine in the method insert() and throws up an illegal Exception in the method UPDATE.This is the error I get when I pass a date "1979-05-02"
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |