[AccessD] My form has a little problem

Stuart McLachlan stuart at lexacorp.com.pg
Thu Jan 19 16:20:25 CST 2006


On 19 Jan 2006 at 11:07, Tina Norris Fields wrote:

> The query qselStudentName looks like this:
> SELECT tblStudent.StuID, tblStudent.StuLname, tblStudent.StuFname, 
> tblStudent!StuLname & ", " & tblStudent!StuFname AS Name

It's a very dangerous practice to use Name as a fieldname.

Name is a reserved word and you can run into all sorts of problems using it 
for a fieldname. Use FullName or similar.



 

-- 
Stuart





More information about the AccessD mailing list