Access Query Error: "Cannot define field more than once"

Can you post the SQL view of your query? Are there source queries referenced in your current query? Can you create a new similar query without issues?

Hi @Chan 49

Thank you for reaching out to the Microsoft Q&A Forum regarding the error you are seeing in Access.

Based on my research, this error message can sometimes appear when there are duplicate field names in the query output, such as when two fields share the same name, even if they come from different tables.

Could you please share the SQL for your query and, if possible, a screenshot of the query design or SQL View (please make sure to hide any personal or sensitive information)? That would help me get a better understanding of the situation so we can go through it together and check if there might be any areas where duplication is occurring. 

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution. 

I look forward to hearing back from you and helping you get this resolved. 

Hi Chan 49, as others have requested, please show us your SQL statement, so we can try to help you further. Thank you.

I finally got into the design view and found the repeated field.