Pip0-
That was SQL not a crystal formula. Since not everyone does SQL I gave you some alternatives.
There are at least 2 foxpro ODBC drivers, because I have 2 of them installed on my machine. Just setup a DSN in control panel, use a foxpro driver, point it to your data and I am sure this will work.
Let me know if you have any questions. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com