software

I use Query to pull in data from several separate excel spreadsheets at once
for data mining. Recently I've come across a query in which no data is
returned for 2 of 8 columns. The fields (columns) being queried are in
general format on the individual spreadsheets and would normally return
numeric data. But in this case, the two fields return nothing (empty set).
If I add a value criteria to the criteria field then it displays the
criteria in single quotes; like the data is being seen as text or something
similar. The other numeric fields don't have this problem and I can't find
an obvious difference in their formatting. I've tried different formats in
the spreadsheets for the columns prior to querying, but nothing works. I'd
appreciate any insights anyone might have on this one.

Thanks in advance.
Might it be a matter of quot;protectionquot; and/or quot;permissionsquot; on the problem
columns?

Vaya con Dios,
Chuck, CABGx3
quot;Terry C.quot; gt; wrote in message
...
gt; I use Query to pull in data from several separate excel spreadsheets at
once
gt; for data mining. Recently I've come across a query in which no data is
gt; returned for 2 of 8 columns. The fields (columns) being queried are in
gt; general format on the individual spreadsheets and would normally return
gt; numeric data. But in this case, the two fields return nothing (empty set).
gt; If I add a value criteria to the criteria field then it displays the
gt; criteria in single quotes; like the data is being seen as text or
something
gt; similar. The other numeric fields don't have this problem and I can't find
gt; an obvious difference in their formatting. I've tried different formats in
gt; the spreadsheets for the columns prior to querying, but nothing works. I'd
gt; appreciate any insights anyone might have on this one.
gt;
gt; Thanks in advance.
gt;
gt;