Table Query

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

Guest

Row Source: Select[primary Name] as Name from Employee Table;
shows

Syntax Error in FORM clause
 
Is Employee Table the name of the table? If so you need to put square
brackets around it because it has a space. I recommend avoiding spaces and
any other special character except for the underscore _ in table, field, or
any other database object name.
[Employee Table]

Also Name is a reserved word. I doubt that is the problem though. Check out:
http://support.microsoft.com/kb/286335/
 
Thanks Jerry for replying what i did was went to row source clicked on ...
thing and opened query got emp tbl and got the query returned there and it
worked.



Nisha P


Jerry Whittle said:
Is Employee Table the name of the table? If so you need to put square
brackets around it because it has a space. I recommend avoiding spaces and
any other special character except for the underscore _ in table, field, or
any other database object name.
[Employee Table]

Also Name is a reserved word. I doubt that is the problem though. Check out:
http://support.microsoft.com/kb/286335/


--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

nishkrish said:
Row Source: Select[primary Name] as Name from Employee Table;
shows

Syntax Error in FORM clause
Click to expand...
Click to expand...
 
Back
Top