Forum Discussion

luitron's avatar
luitron
Copper Contributor
Jul 09, 2019

Deleting Old Records

Hello, I been trying to figure how to create a query that deletes anyone that is not listed on a spreadsheet. I have a spreadsheet (UnitRosterReport 2) linked. I have one query that adds any perso...
access
testmuts's avatar
testmuts
Brass Contributor

luitron 

 

or like

DELETE * FROM UnitRosterReport

WHERE

UnitRosterReport.Emplid NOT in (SELECT Emplid from [UnitRosterReport 2]);

 

 

luitron's avatar
luitron
Copper Contributor
Jul 29, 2019

testmuts Worked! I been trying to figure this out for months now. So simple and yet couldn't wrap myself around it. Thank you so much!

Share