>hello!
>i have this table and my date field gets populated by the date a client was added
>supposed i wanna select all my clients based on the year.
>i have a spinner. that gets the year.
>
>im trying to select all from my table where the year = the selected year in the spinner
>
>so i tried
>

>select * from mytable where clients.date_Add=thisform.spinner1.value;&& i think i saved that value 2 a variable
>into cursor kem
>browse
>

>i wasnt expecting it 2 work and it didnt data type mismatch.
>
>can i use the year separately ? or do i hav to enter a start date and end and query in between those two. that ive done before

What 2 means? 2002?

select * from mytable 
where clients.date_Add >= date(2000 + thisform.Spinner1.value,1,1)
 and Clients.Date_Add < date(2000 + 1 + thisform.Spinner1.value, 1,1)
into cursor kem nofilter