Identifying Missing Data Fields?
I'm hoping someone can offer some insite into this one!
I'm making a database application that will have several users collect data from various sources and enter it as they gather it. I'm looking for a method of reporting progress on entering all the data ... maybe expressed as a percentage. So, say there are 20 fields in a given row, if 5 are still empty, I'd be able to determine that the row was 75% complete. Another useful tool would be to highlight which fields are still incomplete.
Say I've got a table that contains various data about 100 restaurants in my city. After 2 weeks of data gathering, I'd like to be able to see how close I am to having complete data for (restaurant _a), (restaurant_b), etc each individually, or all 100, as a percentage. Then, I'd like to be able to generate a report that show which data are still missing for each restaurant.
I was thinking along the lines of COUNTing NULL values or something, but I can't get it to work properly. Or maybe a giant WHERE clause ...
Anyway, I'm hoping someone else has some experience doing this ...
FROM Table1, Table2, Table3 // , ... (for all tables)
WHERE Column1 IS NULL OR Column2 IS NULL OR Column2 IS NULL // OR ... (for all columns);