Delete Query Help Please!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You can use * as a wildcard, so try criteria R*. This should return the correct records
 
Back
Top