| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query returns blank cells where there should be data
I've create a query to pull a table of account codes from another Excel
worksheet. The table includes numbers enter as text (e.g., 03, 2993LB) and columns with text only. The query returns all the entries in the text only column, but returns blanks for entries like "2993LB" and for other cells in columns with numbers are formatted as text--it returns most of the cells in the column but not others. Any clues on this issue? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Query returns blank cells where there should be data
How are you querying the table? what are your parameters? -- The Code Cage Team Regards, The Code Cage Team 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=36303 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ms query: renamed column returns with blank heading | Excel Discussion (Misc queries) | |||
| MS query returns truncated data to Excel | Excel Discussion (Misc queries) | |||
| sum of blank cells returns zeros | Excel Worksheet Functions | |||
| Formula that returns Col A data in Col B, but omitting blank cells | Excel Worksheet Functions | |||
| stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
Linear Mode
