Hi,
I'm trying to set a default value in an Access table if it is not populated with any data. I have tried the 'default value'property of the table in design mode, but this is only of any use if the whole row is left unpopulated and not if 4 out of the 5 fields are populated leaving a blank one.
I have tried working around it by using a query which pulls back any Null values and ran into the same problem with updating the values of the Null records to something else. I have tried adding onto the query by stating
Update table1
set table1.myname= 'blah'
where table1.myname is NULl
but no go so far.
basically if I could do the whole default value it would rule out the need for the query in the 1st place.
Any help would be appreciated
I'm trying to set a default value in an Access table if it is not populated with any data. I have tried the 'default value'property of the table in design mode, but this is only of any use if the whole row is left unpopulated and not if 4 out of the 5 fields are populated leaving a blank one.
I have tried working around it by using a query which pulls back any Null values and ran into the same problem with updating the values of the Null records to something else. I have tried adding onto the query by stating
Update table1
set table1.myname= 'blah'
where table1.myname is NULl
but no go so far.
basically if I could do the whole default value it would rule out the need for the query in the 1st place.
Any help would be appreciated