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
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