Here is the sql statement:<BR>UPDATE OrgAdmin SET Dept = 'Admn', UpdDt = #5/9/2002#, Level = '1' WHERE (SSN = '652885468' AND FEID = '593755724')<BR><BR>any help?
what's the error? it's usually a sensible idea to mention it.<BR><BR>I think that date may be a problem, actually.
I changed it to theLevel and it worked<BR>
...so he changed the field name in his table and then changed the query and then it worked.<BR><BR>He could have done [Level] instead, of course.<BR><BR>