Leon - I'm going to make some wild gueses about parts of your question. I'd guess you created this table by exporting it from an MS-Access database, right? that's about the only way people commonly end up with MiXeD Case field and tablenames. So, you're also using a version of pgaccess <0.96, which doesn't deal with mixed case very well. Do the visual query design, 'save to query', then edit the sql in the query window, to look like:
select t0."fldIdNumber" from tblpeople t0 where (t0."fldIdNumber" > 1)
BTW, is it tblpeople, or people?
IF that works, upgrade your pgaccess, or submit a bugreport.
Leon Harris wrote:
Ross -- Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005