Invalid query name

[Keith H.]

I have created a query and when I try to test it a
message pops up telling me it's an invalid name. I have
already (several times) done a repair and rebooted the
PC. I have even let Access use a default name. Any
suggestions?

 

[John Vinson]

I have created a query and when I try to test it a
message pops up telling me it's an invalid name. I have
already (several times) done a repair and rebooted the
PC. I have even let Access use a default name. Any
suggestions?

Please open the Query in SQL view and post the SQL text here, along
with the name of the table or tables that you want to include.

Note that if your table name contains blanks or other special
characters, you must enclose the name in [square brackets].

 

[Guest]

John,

For some inexplicable reason I cannot reproduce the error
today. I had deleted all the the offending queries
yesterday and just copied from a working one and modified
it to do what I wanted. That worked ok.

Maybe I just overtaxed my poor computer's brain power.
As I said... I built the same query today from scratch
and now it works. Go figure!

Anyway, thanks for your response.
Keith

-----Original Message-----

I have created a query and when I try to test it a
message pops up telling me it's an invalid name. I have
already (several times) done a repair and rebooted the
PC. I have even let Access use a default name. Any
suggestions?

Please open the Query in SQL view and post the SQL text here, along
with the name of the table or tables that you want to include.

Note that if your table name contains blanks or other special
characters, you must enclose the name in [square brackets].


.