The solution to this problem was tough to work out, but here it is:

The query did contain a mismatch in delimiters for numbers.  Beyond this, 
though, was my use of "reserved words" for field names in the Access 
database.  "Name" and "State" are both reserved.  I changed those and this 
worked wonderfully.

Thanks to all those who helped!

PassLake