>
>Did you try running the 5 SELECTs separately to see if you get the expected number of rows?>
>Well, {blush}, When I was doing a browse to count the number of records that I was expecting, I failed to apply the filter
INLIST(cust_stat,"A ","S ")
to the browse. So the problem is diagnosed as being somewhere between the keyboard and the chair. ;-)
>
>Thanks for the prompting. All is well now.
Glad you got it sorted out!
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up