C
Conan Kelly
Hello all,
I don't us AC very much. When I design a query in SQL view and I enter the
following:
SELECT *
FROM
(
SELECT *
FROM Table1
) as Table2
AC 2003 (& 2002) changes the paren's to square brackets and adds a period
(between the closing bracket and " as"):
SELECT *
FROM
[
SELECT *
FROM Table1
]. as Table2
I just recently went to Office 2003 from 2002, so I haven't used AC 2003
that much. But if I remember correctly, in AC 2002, the square brackets
would always pop up error messages when I would try to switch to Design
view. I would have to change the brackets back to parens in order to switch
to design view. I haven't noticed this problem in AC 2003 yet.
Anybody have any info on this? Anyone getting errors switching to design
view in AC 2003? ...in AC 2002?
Thanks for any help anyone can provide,
Conan Kelly
I don't us AC very much. When I design a query in SQL view and I enter the
following:
SELECT *
FROM
(
SELECT *
FROM Table1
) as Table2
AC 2003 (& 2002) changes the paren's to square brackets and adds a period
(between the closing bracket and " as"):
SELECT *
FROM
[
SELECT *
FROM Table1
]. as Table2
I just recently went to Office 2003 from 2002, so I haven't used AC 2003
that much. But if I remember correctly, in AC 2002, the square brackets
would always pop up error messages when I would try to switch to Design
view. I would have to change the brackets back to parens in order to switch
to design view. I haven't noticed this problem in AC 2003 yet.
Anybody have any info on this? Anyone getting errors switching to design
view in AC 2003? ...in AC 2002?
Thanks for any help anyone can provide,
Conan Kelly