>Thanks jeff it worked, I was wondering if there is a way to do this in view designer or if there was equivlant way of doing these unions in view designer. I am going to use a view to create a grid. Again thanks
>
>nick

I was just thinking.. Do you need a view? Are you going to allow updates and or deletes. If not you could just use the code I gave you in the recordsource of your grid and set the recordsourcetype to sql.

Just a thought.

Jeff