>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