DISTINCT Query probs

[texxs]

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

[thindenim]

I may be reading the above wrong, but would the following not do the trick?

UPDATE Assign SET SalesRep = 'blah' WHERE SalesRep = NULL AND ZipCode = x;

[texxs]

"UPDATE Assign SET SalesRep = 'blah' WHERE SalesRep = NULL AND ZipCode = x;"

Nice try but if I attached that to any type of form, then I would have to run the query once for each zipcode


I'm trying to make a form (access or ASP.NET based) that lists the zipcodes, with an editable SalesRep field next to it. Because we often have dozen of records for each zipcode and we have dozens of inspectors we'd like to "assign" records to.