Update Query

[Faisal Mobin]

I have made A Table named Nurse Information includes filed namely NP , First Name , Last Name ,City ,Certification. Certification field data type is "lookup"which contain 3 values CNP, CFNP,and CPNP.I need to create an update query to assign CNP to all nurse practitioner and then save the query . I want to update my table .



Thanks

[alansidman]

Faisal, first off, you should not have look up fields in your table. While MS has allowed this to happen, all lookups should be combo boxes on forms. Look here.

http://access.mvps.org/access/lookupfields.htm

Now here is a tutorial on update queries.

http://www.databasedev.co.uk/update_query.html

Alan