T
Terry C.
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.
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.