> The syntax will look funny to most as it is VB to an access database, > and no I didn't create it, I just have to work on it.
Jim, could you have VB print out the two SQL statements without the quotes and line continuations, and repost those? It's too hard to read SQL with all the VB stuff interspersed. -- Larry
