"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.

__________________
Take a break and watch some stupid video clips