Spelling Counts
3.
Try it: Spell the Field Name Wrong
Right click the FullName
Field and Zoom to see the code. Please edit the expression as
follows:
Delete the last brace: }
Type a bracket: ]
Edit the Field Name. Type:
Last Name
Click OK to close the Zoom Window. You should return to the
Query.
Try This, Too: Run the
Query
Go to
Query Design Tools ->Design->Results
Click on
Run.
What Do You See?
Microsoft Access will ask you to Enter Parameter Value for Last
Name. This means that the database could not find Field for Last
Name in tblCustomers. The Table has a Field for LastName. They do
not match.
Click Cancel.
OK. OK. That's enough error
testing for now. Close the sample Select Query without saving.