>>>>
>>>>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.

yea i kno...but im wondering why its selecting nothing not even if i hard code a year