Hello! :D
i have the following code

use table
select * from table where client.dateapp=sdate into table apprreport&& somewhere before i have sdate=thisform.date.value
if reccount('appreport')=0
messagebox("no records to display")
else 
messagebox("ken>all")
endif

you see the thing is....the select statement doesnt work if i use a date even if i write out the date like 01/01/1990 i get data type mismatch or if i pass the date to a variable sdate. it copies all the records to the apprreport table. i know nothin is wrong with my select cause if use name or anythin else it works just not date.

and i kinda wanna say

select * from table where client.dateapp>=sdate and client.dateap<=edate into table apprreport

cause i wanna make a report on everybody that applied between the sdate(start date) and edate(end date)