Date Problem. Month & Year To Show or Record

[aamer]

in Date field I just want it to show current Month & Year. and same should be added in table.
how can I write the code. Or how can I do it

[orange]

Just curious--- Why?
If you have a Date datatype, you can store the full Date.

In queries etc you can use Format or Month or Day or Year built in function(s).

In a table called Ancestor, I have a field called BirthDate which is date datatype

SELECT Day([birthdate]) AS D, Month([birthdate]) AS M, ancestor.birthdate
FROM ancestor;

gives a result

D M birthdate
31 10 31/10/1922
22 3 22/03/1944
1 11 01/11/1922
9 9 09/09/1999

[aamer]

thx I solved the problem
In Table Design View and In Format I wrote mmmm - yyyy
this gives me month & year