You cannot create a view which is self-referenced.
From Microsoft Office Access 2003
You cannot create a view which is self-referenced.
The view definition’s FROM clause includes the name of this view. Remove the view name from the FROM clause.
From Microsoft Office Access 2003
The view definition’s FROM clause includes the name of this view. Remove the view name from the FROM clause.