Hi, i'm not a newbie at access programming or anything and i know how to use basic functions like mid(),

Mid ( [nama ] , 5 , 2 )
(where nama is the field I'm getting the numbers from)

Is saying that there is a syntax error, that i've missed a comma or some thing
Type nama = Number

Please Help,,

For Example
i have some data (sample below) that I want to extract part of:
20100301

I want to extract the 2 Number only, that is 03,

How?,,

Thanks

Well, 1 problem is that most objects names don't have a space after them and you have added a space after "nama" (at least in the sample you've shown us).