>>>
>>>lol forgive my lazy internet lingo i meant to work. you're using the year 2000 i really didnt wanna hard code a year
>>
>>Alternative solution would be
>>
>>year(date) = thisform.Spinner1.value
>>
>>this solution is worse if you have an index on date field. Otherwise it doesn't matter and shorter to use.
>
>
>would i hav to write it like (1,1,year) if im using the british date in my tableS?

date function accepts year, month, day parameters. Check Help.