Relatively new to Libra Office. I have a database founded on a table. It has 400 records, each with a dozen or so fields. Four of the fields are pre-filled for all 400 records. I am using a form to fill in data to each of the remaining fields. I need to know how many of my records have been completed. I will use a query or report to list those that are not – this to be used elsewhere as I try and complete this project. In Excel, I simply assigned each record a “complete” field (by entering a 1) and used =sum to tally the completed records. I cannot seem to do this in the table. Moreover, I am not sure if I can pull such a tally out of the table and have it handy on my form. Thanks for any assistance.
Direct in the table: Move to a row with data, which aren’t completed. Click in a field, which should be completed, but has no content yet. Have a look for the symbol for AutoFilter. Click on the symbol. Now you could only see the rows, which aren’t completed.