This error occurs when attempting to create a view where from a query that references two like-named fields.. For example, creating a view from a query that selects two tables that both contain a field named LastUpdated (SELECT table1.LastUpdate, table2.LastUpdated ...) will result in the view having two columns referenced as LastUpdate.
To work around this problem, always assign column aliases to like-named query fields, i.e., SELECT table1.LastUpdated AS table1_LastUpdated, table2.LastUpdated AS table2_LastUpdated...). When not used by target forms or reports, duplicate fields can be removed by un-checking the "Show:" box.