First off, I am very new with Access so apologies if this is super basic, but I am running into an issue with my query and I do not know what the problem is. Here is my code:
SELECT [Long Hours].[STORE NUM] FROM [Long Hours] ORDER BY [Long Hours].[STORE NUM];
The query runs properly, but when I try to sort the data I am given this error:
Syntax error (missing operator) in query expresson 'STORE NUM'.
I know this error is often caused by not bracketing fields that contain spaces, but my fields are bracketed, so I'm not sure what the issue is.