Update primary key field with multiple "where" clauses


Joined
Apr 5, 2014
Messages
1
Reaction score
0
Hi Folks,

In Access 2010 I am trying to update a primary key field (I understand that may be my 1st problem).

When I test with a select query (simply because that is what I am more familiar with), this statement does exactly what I need:
IIf([TrackID]="9" And [Pt]>73,[Pt]+6,[Pt])

But I have not been able to replicate that in an update query:
UPDATE tbl_PT_Veg
SET [Pt] = [Pt] + 6
WHERE [Pt] > 73 AND [TrackID] = "9";

Is this because my update query is incorrect, I am trying to update a PK field, or...both?

I appreciate any advice - thanks!
Joe
University of Wyoming
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top