Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Query fails to include data?
Doing an Excel to Excel query, that is simple enough that the wizard is
adequate. One of the source fields (Price) contains both numeric data, and when such data is not avaiable, a "-". No filters are applied to the price field. In the wizard, preview lists only one item, the "-" unlike the other fields that preview as a complete list. The query correctly returns all the field values except price, which except for the colum label, is all blank. Shouldn't query return the price value even if it is text? Thanks for any suggestions. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Query fails to include data?
Why am i pretty much unstoppable when it comes to excel? -- excelking54 ------------------------------------------------------------------------ excelking54's Profile: http://www.excelforum.com/member.php...o&userid=28348 View this thread: http://www.excelforum.com/showthread...hreadid=479323 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort Excel 2007 to include empty row between data? | Excel Worksheet Functions | |||
ODBC parameter query fails with HAVING | Excel Discussion (Misc queries) | |||
Formatting chart TickLabels fails to include time with date | Excel Programming | |||
1-variable Data Table w/ dependency on MS Query fails to update correctly | Excel Programming | |||
1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) |