Query that would search multiple critera and delete

[justinwright]

I'm looking to structure a query that would match ALL of the following critera:



SITE
PAMOUNT
DateAdded
Initial

Then delete it; these are going to be text boxes on a form with a button to search in case of accidental/erraneous entry.

I would use a unique ID to do it, but I've already implemented it and I'd like to just have something that will specifically match multiple critera (see above) and delete that entry.

The only other issue I see is that the DateAdded might be structured 8/11/2010 or like 12/11/2010, depending on if the month is two-digit or not.

Any help is much appreciated .


Justin

[jzwp11]

I believe that as long as the dateAdded field is set to a date/time datatype (not text), you should not have a problem with the one or two digit months or days. Your delete query would look something like this (you will have to substitute your own form & form control names as well as adjust the table and field names to be consistent with your database).

DELETE myTableName.*
FROM myTableName
WHERE (((myTableName.SITE)=forms!myFormName!mySiteContro lName) And ((myTableName.PAMOUNT)=forms!myFormName!myAmountCo ntrolName) And ((myTableName.DateAdded)=forms!myFormName!myDateAd dedControlName) And ((myTableName.Initial)=forms!myFormName!myInitialC ontrolName));

[justinwright]

Just to update everyone, the code I used for the button (in case this can help someone else in the future), is as follows:

    CurrentDb.Execute "Delete * from List WHERE FIELDONE = " & Me.txtText1 & " AND FIELDTWO = " & Me.txtText2 & " "

This takes the txtText1 and txtText2 boxes and goes through the table called "List" and removes them if each both match for FIELDONE and FIELDTWO for their respective boxes.

Thanks for the help!!!!