When Creating A Multi Row Entry I Get The Error: Could Not Take Attendence Unknown Column '‘FName’' In 'field List'

I was looking at the previous questions such as unknown column in list But found it to not help in my case. I have a form that will take the attendance(which is calling the names a

Solution 1:

Don't use a word processor to edit your code:

SELECT  ‘FName’ ,1
        ^-----^--- 

Those aren't valid quotes in ANY programming language. Since they're not valid quotes, the DB is free to interpret them as being part of the field identifier, and obviously you don't have a field whose name contains the "curly quotes".