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

oh i figure it out...i had to change the months for the end date