The easiest way to do this is use the Expression Builder tool within Access and select the appropriate fields and it will generate the formula for you. Without seeing the data I'm not sure what exactly the scenario is or what you are trying to calculate.
Depending on the scenario, you will likely end up with more round brackets around the formula to make it work correctly, e.g.
Ok, I've been struggling to get my head around what is required here..!
Let me check if another expert can come up with a working formula for you...
I am the person that will be helping you today. May I take a look at the document or a test version of the document?
Please, be forewarned that the site is not secure:- Click the following link: http://www.wikisend.com- Upload the file to that website- Once it is uploaded, the resulting page will display a "File ID" number.- Please, give me that "File ID Number" I will be standing by, looking forward to your response.
Which version of Access are you using? I attempted to open the file, but cannot.
It still is not opening for me. I may be having an issue with my installation of Access.
For this reason, I am opting out of the question and allowing another expert the chance to help.
The next expert will see all that is on this page, so there will be no need to repeat anything.
When another expert picks this up, you will be notified by email.
Thank you for your patience.
Hi, my name is***** original question was whether you could store a calculation in an Access field, and the answer is "not really." You can create a Macro and have the macro trigger when you open a form or a report to populate data based on a formula, but you can't store a formula in an Access field like you do in Excel. Of course, you know you can create calculations through queries, but you said you didn't want to do a query.
Does this make sense? What else can I tell you that would answer your question?
Hi, Rob. Your Excel VBA knowledge is completely transferable to Access. You can code the macro I mentioned in VBA, and have it triggered when a form or report is opened to generate the results of your formulas. You just can't store them as fields in the database.
A more advanced SQL database, such as SQL Server, has something called Stored Procedures that essentially do what you're trying to do, but, especially if you already know VBA, you can code some macros and accomplish it in Access without any problem.
BTW, Rob, if this answered your question, can you please accept the answer and rate me approrpriately? I don't get paid anything for helping you unless you accept the answer and rate me at least 3 stars. Thanks!