"Alan" wrote in message
...
Yer i have tried it with Date/time and put the format to yyyy/mm.

i'm gonna start again tomorrow morning an see what happens,

i know its something i'm doing an it really fustrating lol

If you have verified that the expression should work, make sure that this
calculated textbox doesn't have the same name as any field in your form's
recordsource.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)