A
Access Novice in Confusion
I'm an Access novice. I've found answers like UPDATE table SET
lastname=Left([fullname]],InStr(fullname],",")-1 I vreated a Query, changed
it to Update Query and put that code in "Update to" field of lastname but all
I get is a 0(zero) in last name field. Should code go in "Criteria" field ?
I'm missing something.
lastname=Left([fullname]],InStr(fullname],",")-1 I vreated a Query, changed
it to Update Query and put that code in "Update to" field of lastname but all
I get is a 0(zero) in last name field. Should code go in "Criteria" field ?
I'm missing something.