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?
Also how do I avoid entry boxes popping up and the code just doing queries by what is typed in the code?
Above makes little sense...I mean I want to avoid those 'Enter parameter value' boxes and have the query designated table just appear.
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 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.