Updating Blank Field

  • Thread starter Thread starter isons via AccessMonster.com
  • Start date Start date
I

isons via AccessMonster.com

I have got a table [PRODUCT] from my principal. I just noticed that there
should be a field 'VENDOR'. So I added up a field VENDOR (TEXT). Some of the
records are related to 'ABC'. Some relates to 'XYZ' and so on. Now I want to
fill this field with 'ABC' where field is blank. I believe this should be
done with update query but I dont know how to write 'WHERE' part of
expression and at what place.

Please help
 
Dear Lynn,

Many thanks for your reply.

I am a novice and need more help. I know about queries but i dont know where
to place these commands. Plz help again.

Best regards,

isons

Lynn said:
UPDATE YourTable
SET Vendor = 'ABC'
WHERE Vendor Is Null;
I have got a table [PRODUCT] from my principal. I just noticed that there
should be a field 'VENDOR'. So I added up a field VENDOR (TEXT). Some of
Click to expand...
[quoted text clipped - 6 lines]
Please help
Click to expand...
Click to expand...
 
Since you are probably using the query grid

Create a new query
-- Add your table to the query
-- Select the Vendor field and add it to the grid
-- Select Query: Update from the menu
-- Set the criteria to "Is Null" (No quotes)
-- Set the Update To: "ABC"
-- Select Query: Run from the menu

As always, before doing this make a backup copy of your database. You
cannot undo the action.

isons via AccessMonster.com said:
Dear Lynn,

Many thanks for your reply.

I am a novice and need more help. I know about queries but i dont know
where
to place these commands. Plz help again.

Best regards,

isons

Lynn said:
UPDATE YourTable
SET Vendor = 'ABC'
WHERE Vendor Is Null;
I have got a table [PRODUCT] from my principal. I just noticed that there
should be a field 'VENDOR'. So I added up a field VENDOR (TEXT). Some of
Click to expand...
[quoted text clipped - 6 lines]
Please help
Click to expand...
Click to expand...
Click to expand...
 
Dear John,

Thank you very much. Indeed it was a great help from you. My sincere and best
wishes for your healthy, wealthy and prosparous future.

Best regards,

isons

John said:
Since you are probably using the query grid

Create a new query
-- Add your table to the query
-- Select the Vendor field and add it to the grid
-- Select Query: Update from the menu
-- Set the criteria to "Is Null" (No quotes)
-- Set the Update To: "ABC"
-- Select Query: Run from the menu

As always, before doing this make a backup copy of your database. You
cannot undo the action.
Dear Lynn,
Click to expand...
[quoted text clipped - 17 lines]
Click to expand...
 
Back
Top