nested brackets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to nest brackets "[[]]" in Access' SQL?
Where is the best information to be found about brackets
and their use, specifically when using the period to
perform a replacement function (i.e.:
SELECT * FROM [SELECT Year_Control.StudyYear FROM
Year_Control]. AS Test
will work, but
SELECT * FROM [SELECT [Year_Control].[StudyYear] FROM
[Year_Control]]. AS Test
won't work because of the nested brackets
Why?
 
Never mind. I guess Access just uses the brackets with
the ]. on the outermost nested query for some reason. I
just needed to nest my queries with parentheses instead of
brackets and the whole thing worked out okay.
 
Back
Top