If you showed us some code, we could probably give you a better answer. There are slight variations in which functions are supported in various databases. A SQL statement in access, may not work in remedy.