>I did some testing in the command window, but after i do my report it says record out of range? here is what i did
>create cursor cash;
> (buys y(5),newloans y(5))
>INSERT INTO cash (buys, newloans);
> value (500.00, 500.00)
>
Your INSERT statement was the problem here; either include the FIELDS clause, so that it reads
INSERT INTO cash
FIELDS (buys, newloans) VALUE (500, 500)
or if your intent is to insert values into all fields, presenting the values in the same order as their appearance in the cursor's field list, omit the list of fields entirely in the INSERT:
INSERT INTO cash VALUE (500, 500)
>select cash
>
>do c:\report1.frx