Delete Query

syedadnan · Feb 12, 2016

I am having a query named "Just" with fields;

GR student GR number
MN month format from date showing as Feb-16
Voucher # showing latest voucher numbers issued

I want to make a delete query that to delete record in query "Just" with criteria if found same "MN" (means Found two or more records with FEB-16 or Mar-16 so on) in Same "GR" with highest "voucher #"

Example is attached

syedadnan · Feb 12, 2016

syedadnan said:
I am having a query named "Just" with fields;

GR student GR number
MN month format from date showing as Feb-16
Voucher # showing latest voucher numbers issued

I want to make a delete query that to delete record in query "Just" with criteria if found same "MN" (means Found two or more records with FEB-16 or Mar-16 so on) in Same "GR" with highest "voucher #"

Example is attached

Sorry correct file is attached here

JHB · Feb 12, 2016

syedadnan said:
Sorry correct file is attached here

It is only a Excel sheet.

syedadnan · Feb 12, 2016

JHB said:
It is only a Excel sheet.

Thanks for the reply !!!

Here is a sample database attached

JHB · Feb 14, 2016

Try the below:

Code:

DELETE VOUCHER.[VOUCHER #]
FROM VOUCHER
WHERE (((VOUCHER.[VOUCHER #]) In (SELECT  Max(VOUCHER.[VOUCHER #]) AS [MaxOfVOUCHER #]
FROM VOUCHER
GROUP BY Format([IssueDate],"mm\/yyyy"), VOUCHER.GR
HAVING (((Count(Format([IssueDate],"mm\/yyyy")))>1));)));

Delete Query

syedadnan

Access Lover

Attachments

syedadnan

Access Lover

Attachments

JHB

Have been here a while

syedadnan

Access Lover

Attachments

JHB

Have been here a while

Similar threads

Users who are viewing this thread