can i construct a query to find missing data in a field, then type data into the query data fields and expect them to also be then added automatically into the original tables
can i construct a query to find missing data in a field, then type data into the query data fields and expect them to also be then added automatically into the original tables
A query can return records that do not have a given value
SELECT * FROM table WHERE field <> something;
or if field is null
SELECT * FROM table WHERE field Is Null;
That simple query would be updatable which means could type directly into fields to edit.
Can also run an UPDATE query to populate field.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.