SQL question

  Josquius 16:25 21 Jul 05

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.

Huawei P10 review

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

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now