Oh ya, Access does not recognize the syntax I wrote, it had to be ANSI.