You need to put an IIF statement in to avoid the ? and
get just a blank.
Ex. IIF(ISNULL(SHIPADDR2),'',Shipaddr2)As shipaddr2a
Doug
--- "Ordway, Bruce" <bruceo@...> wrote:
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
get just a blank.
Ex. IIF(ISNULL(SHIPADDR2),'',Shipaddr2)As shipaddr2a
Doug
--- "Ordway, Bruce" <bruceo@...> wrote:
> Hi,__________________________________
>
> I'm experimenting with the Data Conversion tool.
>
> My source is an Access db.
>
> The source table is Part and some records have a
> value in the PUM field (EA, IN, etc..) , while in
> other records this field is blank.
>
> When I add that field to my Data Conversion Query,
> the blank PUM fields show up as "?" when I press
> "Get Results".
>
> My question is this, do I need to populate any blank
> fields in the Access db or is the Data Conversion
> Tool smart enough to fill in the blank ones with
> default value?
>
> This would be good for me to understand because my
> tables tend to have a mix of records with both
> values and blanks in certain fields.
>
> Also, anybody have tips for a new user of the Data
> Conversion Tool?
> It's safe to say that nothing is too simple to point
> out to me. :-)
>
> Thanks,
>
> Bruce Ordway
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com