On lesson 19 of the Access Payables seminar I added the total for the Balance column (time index 4:33). I now receive an error stating 'Syntax error in FROM clause' whenever I run BillSummaryF. I've checked my code against that in the lesson and can find no difference in spelling, spacing, etc. It looks the same. What can be causing this error?  Thanks.

---

Reply from Richard Rost:

"Syntax Error in FROM Clause" usually indicates that the table or query name in your SQL statement is incorrect. Also, make sure the fields you're performing calculations on are actually in the table/query. For example, if you say:

SELECT FirstName, LastName FROM CustomerT

and LastName isn't IN the CustomerT, you'll get an error.