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