Null records

S

Stacy

Just wondering if anyone could help me. I'm trying to
create a report that lists all records and any critical
null fields.

Example...


ID Null Field
1 Name
1 Address
2 State

Can anyone help me...
 
G

GVaught

If you made the ID field required, you wouldn't have this problem or if it
was designated as the Primary key it would not allow null entries.

To find null values in that ID field, create a query and type Is Null in the
criteria section under that field name.
 
S

Stacy

G Vaught,
Thank you for your help. Unfortunately it is more
complicated. I have a large list of items that are either
captured from other locations or are manually entered.
For example, the list may look like this


ID Name Address City State
1 Joe Los Angeles CA

2 Jane 400 Nickel St Miami

As you can see record 1 is missing an address and record 2
is missing the state. I would like to create a report
from this information that contains the following list of
information that tells a specific user to go into each of
these records to update the critical information.

Record Null Field
1 Address
2 State


Do you know of a way to do this....

Thanks for your help!!!!
Stacy
 
Top