Some sample data
table_name field_name data_type length
AircraftRaw RecDate Date 8
AircraftRaw ID Long 4
AircraftRaw fld Text 19
Rec Date |
ID |
fld |
08-Sep-2016 |
2 |
Aircraft N3456 |
|
3 |
|
12-Sep-2012 |
4 |
456723-101 FD34566 |
14-Sep-2015 |
5 |
566788-303 GS23445 |
|
6 |
|
01-Sep-2016 |
7 |
Aircraft N5684 |
|
8 |
|
06-Sep-2013 |
9 |
566788-303 GS23445 |
21-Sep-2012 |
10 |
456723-101 GD23478 |
29-Sep-2013 |
11 |
566788-303 GS45444 |
20-Sep-2009 |
12 |
434545-444 JI345345 |
Select query before doing any update
Code:
SELECT AircraftRaw.RecDate, AircraftRaw.ID, AircraftRaw.fld, Year([recdate]) AS Expr1
FROM AircraftRaw
WHERE (((Year([recdate]))=2016));
Code:
Rec Date |
ID |
fld |
Expr1 |
08-Sep-2016 |
2 |
Aircraft N3456 |
2016 |
01-Sep-2016 |
7 |
Aircraft N5684 |
2016 |
The update query
Code:
UPDATE AircraftRaw SET AircraftRaw.RecDate = Null
WHERE (((Year([recdate]))=2016));
The result:
Rec Date |
ID |
fld |
|
2 |
Aircraft N3456 |
|
3 |
|
12-Sep-2012 |
4 |
456723-101 FD34566 |
14-Sep-2015 |
5 |
566788-303 GS23445 |
|
6 |
|
|
7 |
Aircraft N5684 |
|
8 |
|
06-Sep-2013 |
9 |
566788-303 GS23445 |
21-Sep-2012 |
10 |
456723-101 GD23478 |
29-Sep-2013 |
11 |
566788-303 GS45444 |
20-Sep-2009 |
12 |
434545-444 JI345345 |
I hope this is helpful.