Clearing a column?

[afrenz]

Ah I see. Not me! I've never posted at that site!

Sorry, I picked the wrong one. It s/b 'alansidman' posted above!

[Micron]

Blimey, some convoluted solutions there?

Crikey!

Well doesn't anyone else think that unless (maybe) you're seeding tables for the first time you shouldn't be playing around in them? Besides, doing ctrl+H robs a novice of what an update query is, not to mention how to create this simplest of updates. Something like
UPDATE table1 SET Myfield = Null;

[afrenz]

Welshgasman,

I like your simple approach and I'd like to use it.

UPDATE table1 SET Myfield = Null;

How do I enter and run this in Access? All I find are Wizards and I do not see how to enter this code. Is performed outside of Access or is there a screen that allows this type entry?

[Micron]

This was explained in post 2 (and very much in post 8). If you don't understand what is suggested you could always Google and save yourself some waiting time? Something like "how to create update query in Access?"

Create a query, either by going to design view and dragging in your table, choose the Update option from the ribbon and put Null on the criteria line for that field. Or open a new query, switch to sql view and paste that code in.

Looks like you picked/quoted the wrong person again?

[afrenz]

This was explained in post 2 (and very much in post 8). If you don't understand what is suggested you could always Google and save yourself some waiting time? Something like "how to create update query in Access?"

Create a query, either by going to design view and dragging in your table, choose the Update option from the ribbon and put Null on the criteria line for that field. Or open a new query, switch to sql view and paste that code in.

Looks like you picked/quoted the wrong person again?

OK, I think I got. Sorry for the confusion. Trying learn how to use the forum!