Are you in Access doing this? Try using the query tool then look at the sql.
>The first part worked but second part is not. It is giving me a syntax error.
>
>sherry
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown