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