>> Well I STILL cannot seem to make my report for a
>> kennel company that shows the qty of animals due in
>> from current date to ??? (infinity). The cursor thing
>> is new to me and does not make much sense. I probably
>> need a simple piece of code for a simple BABY programmer
>>
>> any help would be appreciated.
>
>what about something like :
select * from kennel where arrivaldate>=date() into
>cursor mycursor
>
>Arnon
Fred, keep in mind ALL of us had to learn the difference between the cursor where you're typing and a cursor-as-table.
Arnon's code will give you a temporary, read-only table (called a cursor to differentiate it from the tables on disk). Next you design your report to use fields from 'mycursor'. Don't just drag fields from your original table, or the report will look at that table instead of the cursor.
It's easy to get bogged down in this. If you want more help, feel free to e-mail me.
Barbara