>>>>>>
>>>>>>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
>
>Try first
>
>select * from myTable where datefield >=date(2002,1,1) and datefiled < (2003,1,1)
>
>Does it bring you records? If not, in means all records are deleted or don't exists for the year 2002.
i changed the months seemd to fix it