Update primary key field with multiple "where" clauses

J

JC_81301

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
 

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

need to update record with autonumber as primary key 3
DSum update query with multiple fields 0
UPDATE query creation for SQL 6
Update query. Within the same table: populating field 2 from field 6
Problem with an Update Query 3
Creating update query to update non primary key. 1
Access Daily Entry with multiple entries per field 0
Update the values in a table from another table 1

Top