I have a client with one last holdout FoxPro 2.6 application. It manages all
of their incredibly complex billing and is a work of art and works beautifully
and someday we will upgrade it, not to make it better, but just because we will
have to. But for now, just accept that fact and move on. 
The woman who does the invoicing noticed an odd inconsistency that did not
affect billing but a payroll report that was missing one person's 3 hour stint
for a particular day - one of 3 rows that made up one guy's particular
day.
That report is created by a union of two queries. The first picks up all the
data, the second picks up any body who didn't have any hours that week (10 maybe
15 extra). I looked and looked at this then broke the queries into two. The
record was there. Ran the queries with the union, the record was gone and the
row count was off by one.
I have been fiddling with this all morning (it's a disease, what can I say?)
and there is no rhyme or reason for it. So I just bagged the union and did two
queries and appended the results to each other.
But, no complaints. We are all ecstatic that this 8 year old program (which
gets tweaked here and there from time to time) still works on the new computers
and is great. Thanks to all who are responsible for that!!
http://www.AcehAid.org