Hi Jeff,
Sorry, the table is called Task and I am using Task in the where clause. I am at a loss. The view is based on a table rather than query. If I change the macro say to a unrelated field (not related to another table) such as status e.g. Where Task.Status="Completed" it seems to work...