Updates

[lambda75]

I have a table that i need to update.

My table has fields called: Aircraft, W1, W2, createddate

the aircraft has 3 records in it. a, b, c and thoses three records have a date of 12/31/2004

how can I add the value of 4 to aircraft b in field(column) W2



thanks

jose

 

[mresann]

UPDATE Table1 SET Table1.W2 = 4 WHERE (((Table1.aircraft)="b"));

Also, check under Update Query in Access Help.