>For me _TALLY always equals 0 whenever there is no matching records, so it must be caused by one of your settings. However, if you really don't care about the result, and only need to find the number of hits, if any at all, you can use another solution:
>SELECT MAX(draw.drawlstchg) FROM draw ;
> WHERE draw.obligor + draw.obligation + draw.unit = ;
> m.obligor + m.obligation + m.unit ;
> TO SCREEN NOCONSOLE
>IF _TALLY....
>
Tore,
It's change in behavior in VFP9. See
Re: Using form property as control source for text box Message #
996153 for details.
--sb--