Abandoned Fields Report/Cleanup

fsidaway-wolffsidaway-wolf Moderator Posts: 4 mod
Is there a report that allows me to search for how many records each custom field contains (how many records have that field X filled in)? 

Over the years our method/plan for how we use the Data Cards has changed, and we now have a quite a few "fields" that don't have a corresponding data card entry anymore, and I'd like to eliminate as many as I can to clean up our sql tables.

My current plan is to import the fm110fil table into Access and try to create a count query against that.

Comments

  • BCranstonBCranston Moderator Posts: 37 mod
    Perhaps...Try System > Database Analysis > Documents report? I use it occasionally to see how things are going :smile:

    -Brian
Sign In or Register to comment.