Yes, the code from the Designer will be wrong. Use the Designer's SQL code as a starting place and correct/add to it to get what you need. If you get two tables done in the Query Designer it's usually easy to add the third in a PRG.


>Thanks Barbara,
>
>I tried running the code in a prog and it still came up with the SQL error. Clicking ignore and then running again works but the query output still has the same invalid data. I guess the SQL code being generated must be wrong!
>
>Chris