Agnes - thanks. You were exactly right. I set the filter to balance > .01 and everything was fine.
>>I'm running a report using a remote view of Access data. I wish to filter out records that have a zero balance. The SQL statement reads:
>>SELECT Client.FirstAppointment, Client.Balance, Client.Last,;
>> Client.ClientNumber, Client.ClientActive, Client.Collections;
>> FROM Client Client;
>> WHERE Client.Balance > 0
>>When I run the report, it will show some, but not all records that have a zero balance.
>>When I browse the view from the command window:
>> ? balance shows 0.00
>> ? balance = 0 shows .f.
>>Any ideas?
>>Thanks.
>
>Hi Ken
>It's simple, they are not 0 it only looks like. This rounded is by foxpro's SET DECIMAL.
>
>If you wnat to have a look try something like
>
>? balance *10000
>
>
>Agnes