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?

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