Hi Carl,
Three things will be helpful in solving this problem:
1.) Don't type in all caps. It's very difficult to read and is considered shouting.
2.) Open your query in design view. Click on View > SQL View. Copy the SQL statement and paste
it into a follow-up message.
3.) Provide the name of your query, just in case something funny is up there.
Are you using any reserved words in Access and / or JET for the names of fields, tables, or
queries?
List of reserved words in Access 2002
http://support.microsoft.com/kb/286335
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/kb/321266
Tom
____________________________________________
WHEN RUNNING A QUERIE EVERYTHING WORKS FINE, BUT WHEN TRYING TO EXPORT IT I
GET THE ERROR "CIRCULAR REFERENCE CAUSED BY "QUERY_NAME""
ANYONE KNOW HOW TO FIX THIS?