Need Insight to Delete Query Method

[Dalan]

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

[Wayne Morgan]

DELETE * FROM tblTable1 WHERE tblTable1.RefID=545 And
tblTable1.RefDate=#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.google.c om...

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

[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******************@newssvr31.news.prodigy. com>...

DELETE * FROM tblTable1 WHERE tblTable1.RefID=545 And
tblTable1.RefDate=#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.google.c om...

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