Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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