SQL question

  Josquius 16:25 21 Jul 05
Locked

How would I write SQL code in microsoft access where the name of one of the tables I want to use has a space in it?
I have tried writing it as it is and _ though none seem to work, what is the proper way?

  Josquius 17:03 21 Jul 05

Also how do I avoid entry boxes popping up and the code just doing queries by what is typed in the code?

  Josquius 17:46 21 Jul 05

Above makes little sense...I mean I want to avoid those 'Enter parameter value' boxes and have the query designated table just appear.

  Sir Radfordin 19:19 21 Jul 05

Using " " or ' ' around the table name may solve your problem. One of those things I can never remember how to do and don't have an SQL database to check at the moment.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…