simple INSERT INTO problem 1

[marc7]

i am taking information from an asp page and trying to enter it into an access database. i need to update 2 fields in an existing record (the fields are blank). here is the sql, any ideas why it is not working? the Received field is formatted as "Date/Time" in access.

INSERT INTO Files (Received, FTP)
VALUES ('1/1/2004', 'CD')
WHERE Id='1' AND
Contact='RT' AND
Category='Art'

thanks for any help...

 

[swampBoogie]

Update files
set received = '1/1/2004',
 FTP = 'CD'
WHERE Id='1' AND
Contact='RT' AND
Category='Art'

 

[r937]

what swampboogies said, only probably with octothorps instead of quotes to delimit the date string...

Update files
set received = #1/1/2004#, ...


rudy

http://r937.com/

SQL Consulting