UPDATE field with year and month

[sal21]

I have a field named DATE1 = 03/12/2009
an dhave field Month and field Year ...
How to update Month and Year fields only with Year format YYYY and Month format MM

un this case Year 2009 and Month 12
month and year are text format

[HansV]

I don't understand your question.

(You haven't reacted to the replies to your previous three threads... )

[sal21]

I don't understand your question.

(You haven't reacted to the replies to your previous three threads... )

In effect i have this 3 fields:

DATE1 Year Month
12/12/2005
11/11/2006
....

i need with a query

DATE1 Year Month
12/12/2005 2005 12
11/11/2006 2006 11
....

update the field Year and Month...

[HansV]

Oh, OK.

Year: Year([DATE1])

Month: Month([DATE1])

Was that so difficult?

[sal21]

Oh, OK.

Year: Year([DATE1])

Month: Month([DATE1])

Was that so difficult?

TKS! WORK!
But sorry me... my Boss love Access... me not!
for my Boss all is so simple