Hello! :D
i have the following code
use table
select * from table where client.dateapp=sdate into table apprreport
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)