Thanks for your input. I agree, the problem is the Jet reserved word.
In developing a different query from the same DB I ran into a similar
problem with a field named QUOTED_STREET_RENT/SF. My guess is that
the presence of the "/" character is the problem. Any thoughts on
this?

BTW, someone else designed the DB. I'm not really familiar with Jet
and need a list of restricted words. Know where I can get this info?


On 27 Feb 2004 01:49:17 -0800, (onedaywhen)
wrote:

Sorry for mentioning MS Query, it is irrelevant to this problem. Just
after accusing someone of not reading the OP, I fail to spot the
mention of a recordset, ruling out MS Query!

I think the problem here is that SIZE is a reserved word in Jet.

ADO is the data access technology being used in this case to
communicate with the data engine. MS Query is an alternative data
access tool and isn't involved in this case. Jet is the database
engine, which does all the work of retrieving the data from the .mdb
file. MS Access is a GUI front end tool for designing Jet databases
and building forms and reports with controls bound to a Jet data
source (yuk!) and also isn't used in this case.