Imaginary table in a MS Access 2000 Database:

Table Name: Assign

Column Names/type

Column 1: ID
Primary Key, data type=text
must be unique

Column 2: ZipCode
text

Column 3: SalesRep
text

I'm trying to perform the following:
Change the value of the SalesRep column for all records with the samezipcode WHERE SalesRep=NULL.

We need to assign thousands of these records to dozens of reps based on the geographical area (zipcode) and how many we feel they can do in a week.

right now were printing a report and having an exec do the "assigning" on paper. Then it has to entered into computer by someone. Very time consuming, so I'm making a form in the DB or web based that will help.

I can get a list of what I need to see but I can't get an editable one:
SELECT DISTINCT ZipCode, SalesRep
FROM Assign
WHERE (((Assingn.SalesRep) Is Null)) = True;


GEEZ, I was soooo wordy above, sorry about that . . .

What am I missing?

Thanks all

__________________
Take a break and watch some stupid video clips