>Hi Kev - thanks for the reply - I am using the Query Designer and it throws a Syntax Error with the Ampersand! I have tried modifying the SQL but it doesn't like it!

Chris

Download E-View from the Downloads section, the Query Designer is very poor, and you will be better off either coding the view yourself, or use E-view.

Kev