Robin, > It seems the desc (a memo type field) is giving me the syntax error. DESC is also a reserved word in SQL ( used in the ORDER BY command, for descending). Change that, like you did for date, and you should be fine. Hope that helps, Chris Evans chris at fuseware.com http://www.fuseware.com