How do I delete all records in a query where the description starts with the letter R?
D Diane Apr 12, 2004 #1 How do I delete all records in a query where the description starts with the letter R?
P Perry Apr 12, 2004 #2 DELETE * FROM [MyTable] WHERE Left([Description],1)="R" Adapt above code to match yr situation. Krgrds, Perry Diane said: How do I delete all records in a query where the description starts with Click to expand... the letter R?
DELETE * FROM [MyTable] WHERE Left([Description],1)="R" Adapt above code to match yr situation. Krgrds, Perry Diane said: How do I delete all records in a query where the description starts with Click to expand... the letter R?
