I'm having issues trying to run a like query in MS Access. When I run the query it continues to give me an "Unknown" error. The table that I'm querying from is a linked to an excel spreadsheet. I'm running the query in Access through the query module. Please help!
SELECT Everyone.[First Name], Everyone.[Last Name], Everyone.[Entering Grade], Everyone.[Parent/Guardian Name], Everyone.[Tuition Options]
WHERE Everyone.[Tuition Options] Like '*Option A*'