Does a Joined query allow one to modify data in a column?
( the column seems blocked.....)
In other words,
have a left join that is matching on SSN.
We are joining a vendor file to our table.
If the vendor ssn, is blank, i want to type into the blank column a valid SSN, and
then run the query again, with no rows appearing, as all issues would be resolved.
However, query does let me enter SSN in the column that has nulls
Below is a sample mdb, where the query disallows me from entering data in the the field
that contains NULL.
tx in advance for your help, sandra