No that is not the DB column name, my code on the real page has the correct name. that was used only to describe the situation.
Also, I had the big "O" in the above code, was a typo..
It appears to me that my queries that were previously run are stuck in limbo somewhere in MS Access' memory
any other tricks i can try?
Is there some function we can run to somehow clear the memory and then i can call the SUM function above??
thank you for sticking with me this far. I really appreciate it.