Is it possible to have a Field that contains data that is the product of a calculation?
Thats to say the field Automatcally performs its own calculation to detremine it's own data?
IE I have a field called Approximate Age of Animal and another called Date Entered into System. Using these Two I can Calculate its current age. (done so in a form) BUT what happens if the user wants to Run a Query on this Current Age? I also have an empty field called Current Age.
It seems to be more of a spreadsheet thing. But Isnt there a way to do it in Access? it must happen allthe time?
I have a splash screen at start I can Put code into at start up with VB but surley theres a more elegeant solution?