Storing a count???

[Guest]

{Disclaimer: I think now I'm just getting anal about this}

I know I'm not supposed to store a calculation,,,but(there's always a
but-and I'm usually it )

When recording an inspection log, basically an inventory of various
equipment (CO2 cylinders on inspected vessels) the inspector is required to
count the cylinders, log each by serial number, give total counts in each
category=fixed, portable,chemical, foam etc. Now,,I'm using a query to
double check their counts (once inventory entered and inspector's totals are
input-I run the query to confirm their counts totals by category) Is this bad
form?

Sorry if this is a ridiculous question....
Mary

 

[JohnFol]

No, as it sounds like you need a statement which reflects an actual
situation that occurs at a particular point in time.

ie at the time of performing the count, you need to know the result of the
query compared to a manual count. I'd expect you to have some sort of Audit
table with a DateOfCount, EnteredCount, CalculatedCount stucture