Eine Einführung in

SQL

SELECT a column whose name contains spaces?

MS Access
If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do?	SELECT [Account Balance] FROM SpaceMonster
Specific to MS Access
Use square brackets - better yet - don't put spaces in field names.