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