Re: How do I use "Action Queries"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In the query builder, create a select query and then go to Query>Delete Query
and change it to a Delete Query. Use a backup of your db and practice a bit
to see how it works.

Virgin Islander wrote:
I need to delete an item from a table, using a query and it looks like
"Action Query" is the way to go, but I cant find anything in Access training
that shows me how to use it. Can anybody help please?

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200610/1

.

Relevant Pages

  • Re: Simply confused - Query stopped working
    ... This author may have received products and services mentioned ... I wasn't too hot to the idea of going back to my last backup as I was just ... I created a complex report built upon a set of queries. ... The first query runs fine. ...
    (microsoft.public.access.queries)
  • Re: Delete Query - Delete matching records from 2 tables - Access 2000
    ... BACKUP your data before attempting the following. ... To delete records from Daily Check the query might look like ... WHERE policy in ... FROM INNER JOIN Retention ON.policy = ...
    (microsoft.public.access.queries)
  • RE: Another Dlookup question
    ... > subtable that lists the number of times a client calls in for that ... > backup. ... It's linked to the tblAddress. ... > Here's what I have to do in my query: ...
    (microsoft.public.access.queries)
  • Re: My query is empty. How do I reestabish relationships to add d
    ... Following is the SQL and a little other information on the 2 queries ... Following the Query is some information on the Customners ... Backup, backup, backup! ... consider posting the SQL statement of the query that isn't ...
    (microsoft.public.access.queries)
  • Re: Delete Query - Delete matching records from 2 tables - Access
    ... BACKUP your data before attempting the following. ... To delete records from Daily Check the query might look like ... WHERE policy in (SELECT Policy From Retention) ...
    (microsoft.public.access.queries)