Roedd <<Michael Malinsky wedi ysgrifennu:

I know how to create an SQL statement in VBA, but the problem that I'm
running into with this one particular database (not of my design) is
that the tables and queries have names that contain spaces (i.e.,
Customer List). Apparently the SQL statement doesn't like the space
in the table/query name. I've tried a couple of different things
without success. Can anyone help with with this problem?


What couple of things? You're in danger here of getting loads of replies
with stuff you've already tried.

Put the field names in [] square brackets.

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.