>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
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com