"Steve" wrote:

Repeatedly MVPs advise posters not to use spaces in object names and here
you are going against "learned" advise and putting spaces in query names????

Correct.

I view myself as one of the "learned" advisors. And I hold a
contrary opinion to most on this topic. As I do others. So my
attitude varies somewhere between tough and who cares.

So besides wasting a lot of time typing long object names,

Reread a previous posting on this topic. I do *not* type long object
names.

you have to
remember to put square brackets around your query names.

Whenever I use queries embedded in VBA I create the query the first
time using the query builder which takes care of everything anyhow.
So that's a non issue too.

Do you put square
brackets around table names or do you use another set of rules for table
names?

No, no need.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/