Update Query

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

I have a table in which I import data from an outside
source, once the data is imported, I need to do an update
query on the table to update a blank field (which is not
imported from the outside source). The blank field is the
CD-ROM#.

My goal is to import the 5000 records and then run the
update query and have it ask for the CD-ROM#, I insert the
number and then it will update all the records I just
imported (which will have a blank CD-ROM# field).

Does anyone know how I would write this query?
ANY suggestions will be greatly appriciated.
Thanks
Becky
 
Does anyone know how I would write this query?
Click to expand...

Create an Update query based on your table; on the Criteria line under
the CDRom field put

IS NULL

to select only those records for which the field has not been filled
in, and on the Update To line put

[Enter CD number:]
 
Thank You Thank You Thank You!!!!!!!!!!!!!
It worked.
-----Original Message-----
Does anyone know how I would write this query?
Click to expand...

Create an Update query based on your table; on the Criteria line under
the CDRom field put

IS NULL

to select only those records for which the field has not been filled
in, and on the Update To line put

[Enter CD number:]



.
Click to expand...
 
Back
Top