Performing basic math on a specific column/row

lantiis

New member
Local time
Today, 09:34
Joined
Oct 10, 2014
Messages
2
I am completely new to Access and how to do anything with it outside of tables and queries. I have been tasked with creating a form to do fairly basic things. Via tutorials I have managed to use the Expression Builder to do virtually everything I need except one thing.

I need to pull a value from row 2 in a specific column from a subform and subtract it from row 1 in the same column and subform leaving behind a + or - number for the user. Similarly, I need to do the same but subtracting the LAST ROW from row 1. If there is only one row at the time the operation is being performed, a value of No Data needs to be returned instead of a number.

I have not figured out how to do this and it was suggested to write a procedure? I have no idea how to do that either.

Any help or insight would be greatly appreciated.
 
Thank you. I have been there and used some of their tutorials to make it as far as I have. I haven't found a tutorial there for what I need now though. Can you point to one that I could use for this??
 

Users who are viewing this thread

Back
Top Bottom