MS access - clearing

[Drew_gable]

Hi guys ,

I need a little advice,

I need to reset ALL the contect with in a Selected colloum in my access database

Database name is mutisavers.mdb
table name is table1
collum name is PoS_scan

Any adice or same code is MOST welcomed

Thanks in advance
Drew

[Phil Weber]

Assuming that PoS_scan contains Text data, you can do this:

UPDATE table1 SET PoS_scan = ""

or

UPDATE table1 SET PoS_scan = Null

[Drew_gable]

Thanks

I have to say i was expecting pages of code but I like the simple ways ;o)

Drew

[Drew_gable]

It is not working.

Am i doing something wrong

What i forgot to mention is i am using a vba program as my interface to the database (ado)

do i need to change the coding some how??

[Phil Weber]

I don't know. Please post your code and describe how it is "not working" (error messages, etc.)

[Drew_gable]

The code I am using is as follows

UPDATE table1 SET PoS_scan = "0"

I am not getting any error codes or anything do I need to link it to the data1 control unit before I run the command?

[Laurel]

Post more of your code. We can't tell if it's a syntax error or WHAT with that little piece of code!

[Drew_gable]

it's ok guys I have found a quicker way too re set my figures )