Thanks for responding to my question.
The SQL is attached. I'm no expert so it's probably over complicated,
but it did work for the first 800 vehicles for one client. (BTW I use
the query builder, I'm not good enough to write raw SQL)
I just turned the make-table back into a select query, to check it that
way, and it still crashes.
Can you give me a pointer on the fundamental area of the problem? Does
that error message categorically mean that the new (additional) data I'm
using has an error? Or could it be a red herring and there's something
wrong in the way I've written the query?
Thanks
Bob
n message <11*********************@74g2000cwt.googlegroups.c om>,
pi********@hotmail.com writes
>Bob,
the background info is helpful, but we need more info. Are you running
a query? Could you post the SQL for it? What are the field types
involved in the joins and the where clause? Maybe they don't match and
Access isn't coercing them... So make sure they're of the right same on
both sides of the join. If you're using Autonumber on one side, the
other side would be a Long Integer.