>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]