>>>
>>>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.
If it's not broken, fix it until it is.
My Blog