I'm in the process of finalizing several data forms for a salmon hatchery. I'm wondering what the logical route would be to create a summary form, perhaps read-only, that the hatchery manager can view to look at values that have been auto-calculated from one or maybe two other data forms. This would be a form that would change on a weekly basis depending on inputs to other forms.
For example, inventories for each pond containing fish are done on a weekly basis; number of fish per pound, water flow into the pond, etc., and these are all recorded already in a form. On a daily basis, mortalities of fish are counted, and again are recorded in a separate form. From the values above, a simple calculation will result in us knowing total inventory in the pond, number of pounds to feed on a daily basis, the flow index (pounds of fish per gallon per minute), the density index (number of fish per cubic unit), and so on.
Since these are relatively simple calculations, my hope is to have a summary page that the manager or his technicians can quickly view at a glance to make decisions. For the sake of other data collected, the values in a summary page wouldn't mean much to me since I probably wouldn't be adding it to my Access database.
Any ideas on how to make this a reality?
Please sign in to leave a comment.