>how would I display all records before a specific date.
>I have a field called kdate which displays when a record was created
>I need to call all records before April 2013.
>
>thanks
>k
It really depends where you want to show it. Tore's reply is appropriate for an editing form. For a report, I would SELECT all data into a cursor, something like this:
local ldDate
ldDate = ThisForm.LblDate.Value
SELECT * FROM MyTable WHERE kDate < ldDate ORDER BY kDate INTO CURSOR Temp
REPORT FORM MyReport
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)