Update Query on empty fields

[bryan]

I'm new to Access and I'm trying to create a simple database derived from another application's data. Our process is to export a tab delimited text file from another application (Avid Media Composer, in case it matters) and import into an Access table. This works well, except, in some cases, there are fields that are empty because the Avid application does not add some data in certain situations. We would like to add this data in Access. I've tried following instructions for creating an update query with the criteria "Is Null", but so far, haven't been able to update anything. Is this the correct approach? Can someone walk me through the process?

Thanks,

Bryan

[ajetrumpet]

what have you tried?

if you want to update all the nulls with one value, press Ctrl+F on your keyboard on the datasheet and use the replace feature. it works just like the qry wiz. find 'NULL'. if that doesn't work, the imports might be zero length strings instead of nulls. if that's the case, try typing nothing into the find box. leave it blank.

[bryan]

Thanks! That works and it's a lot simpler than creating a query.

[ajetrumpet]

Thanks! That works and it's a lot simpler than creating a query.

Sure is! FAQ coming soon on that process!

thread solved...