am attaching sample of database:
Just the table-(table1)-
at present I sum [time spent] and divide by count of records-and I have queries and reports built-
Now management want me to still sum all of the [time spent] - but when I divide by count of records - I need to not count pending completion records - (and there are a couple hundred)
So in this sample database I have attached- there are 11 records - but 3 are pending completion- so I need to divide sum of time spent by 8-
do not have idea of how to go about this-
my original thought is I would like to be able to change the table-outside of the database and then import it back in and not change other parts of database. but am confused.