Is there a way "using NZ or whathaveyou) to convert null values INSIDE A TABLE to "" using an update command or other method. i know how to do it in a query, but I would like the imported data itself manipulated.
thanks for the help
Novice
Windows 7 
Access 2007
Is there a way "using NZ or whathaveyou) to convert null values INSIDE A TABLE to "" using an update command or other method. i know how to do it in a query, but I would like the imported data itself manipulated.
thanks for the help
Administrator
Windows XP Access 2002
An update query using what you described will do what you are asking. Is that not good enough?
Posting Permissions
Reply With Quote