can I do math in an Access Database??
I would like to say that a particular field is the sum of the same field in the previous 10 records.
is this possible?
thank you for your time and have a good day
Printable View
can I do math in an Access Database??
I would like to say that a particular field is the sum of the same field in the previous 10 records.
is this possible?
thank you for your time and have a good day
Uhm.. you can't do math "in" a database.. but you can get the two values, add them together and store the result in another field. If it's just going to be displayed, you might be better off just caluclating this on the fly.