Help creating a quering use IF

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

I need help I am not sure how to this. I have created a
table. That has student information. This table is a
listing of students that are registered for a class, There
are multi-classes. All I have that is unique is the class
#. I want to update only certain fields in this table, but
the criteria has to equal the course number. I am not sure
how to do my query. I only want to update the records if
the course number eqauls the course I enter. How do I
create the query to ask me the course number. I hope that
I have explained myself & I hope some can help.

For instance I only want to update the records in a table
that the course number equals '3100' I have created an
update query to update certain fields, (course name, # of
hrs, location, & instructor).
please help...Annette
 
in the table under the field for course # put in the
criteria row [Course #]. When you run the query it will
prompt you to enter in the Course # and return only
records that match that #
 
Back
Top