Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Update Query

Hi,

I have an update query which specifies two accounts which i want to delete from another table if it matches this citeria

IIf(Mid([TRANS_REF],3,1)<>'D',[TRANS_REF])

I am making this in the design view, can i update into the same table i am using for the criteria, is that possible?

So i have one table and am saying, if any entries match this criteria, delete them

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you're asking if you can do an UPDATE and DELETE in the same query then no, you cannot. You must run 2 queries - one to update, and a second to delete.
0
 
Seamus2626Author Commented:
Perfect, changed it to delete!
Thanks
Seamus
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now