It would be good to see a pic of your table relationships if you have created them. Access is nothing like Excel, and that has likely got you off on the wrong foot. In addition, calculations are rarely stored in Access tables because of volatility of the inputs, so calculations are done on the fly in queries and shown on reports and forms. A calculated table field is another matter, but it's something I rarely use. If this db is to be used by others, it is also ill advised to allow them to work directly in tables as if they were spreadsheets.
See "How to attach files" at the top of the page for help on posting pics. You just can't paste them in a post on this site.
Last edited by Micron; 02-13-2024 at 10:11 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.