Delete Query Help Please!!!

M

Michael O'Dell

Being new to Access, I am trying to run a delete query where I need to set the following guidelines
(I need to completely remove all records associated with the 'description'). I need to be able to delete all descriptions that start with the letter R, but I have to do this running a query
I am not sure how to set this up and I am having no luck changing the criteria
I would appreciate any help
Thanks
Michael O'Dell
 
S

Steven

try a criteria like

Left([cus_billname],1)="R"


Michael O'Dell said:
Being new to Access, I am trying to run a delete query where I need to set the following guidelines;
(I need to completely remove all records associated with the
Click to expand...
'description'). I need to be able to delete all descriptions that start with
the letter R, but I have to do this running a query.
 
Top