NEED HELP WITH SQL STATEMENT 1

[TNN]

Can anyone please tell me why the following statement will not work. I'm using a access 2000 database.

UPDATE BASSPERS
SET GENDER=(SELECT GENDER FROM BASSPERS1
WHERE EMPNO=1066)

Get error "Operation must use an updateable query."

TNN, Tom
TNPAYROLL@AOL.COM




TOM

http://WWW.TNPAYROLL@AOL.COM

 

[DougP]

try this:

UPDATE BASSPERS1 INNER JOIN BASSPERS ON BASSPERS1.EMPNO = BASSPERS.EMPNO SET BASSPERS.GENDER = [BASSPERS1]![gender]
WHERE (((BASSPERS1.EMPNO)="1066&quot);


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[TNN]

Thanks DougP,
That works just fine.
I was using syntax from ANSI SQL. Guess it's not applicable for access/SQL.
Thanks again
TNN, Tom
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM