Error in Performing Data Entry with SQL

[Lou_Reed]

I am working in the tutorial whose link is now shown:

http://www.functionx.com/access/Lesson31.htm


now when I try the section performing data entry with SQL, I am
at the point where I have typed the SQL statement:

INSERT INTO Employees(EmployeeNumber, [Last Name], Gender, HourlySalary)


VALUES ('227947','Jameson','M',18.85);

It chokes on the "unknown variable" HourlySalary, I could find nothing wrong with it.
I then deleted my HourlySalary and copied theirs directly from the tutorial. It still chokes on HourlySalary.

Now I am not sure what to do since I have taken their script and copied it to the SQL window.

What is wrong here?

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[June7]

I see nothing wrong with the statement. HourlySalary is actually a field in the table? It is Double or Decimal number field type?

Odd that this tutorial sometimes uses spaces in field names. I guess that is deliberate to demonstrate the differences in using fields with and without spaces. In a real db it would be desirable to not use spaces.

[Lou_Reed]

I believe that it is money. I cannot be sure however. It is hourly salary.

R,

Lou Reed

[Rawb]

I was able to create the Table as described and insert the Record without any problems. Based on your error, it looks like the Table doesn't have a Column named HourlySalary. I would try to confirm that the Column exists and the spelling is correct.

If everything looks correct, can you provide a screenshot of the design View of your Table or a copy of the DB for us to look at?

[Lou_Reed]

I will try.

Thanks for your help.

R,

Lou Reed