Table Query

[nishkrish]

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

Syntax Error in FORM clause

 

[Jerry Whittle]

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/

 

[nishkrish]

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

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.

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

Syntax Error in FORM clause