This is a forum for SQL server. Many queries for SQL are not compatible with MS Access. You will have better and more accurate respons if you post your question in a MS Access forum.
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **