Try the following code. Insert it into the Memo fields AfterUpdate event. Also if your working on a network you can take this a little farther by adding the User Name of the person logged onto the computer to your time stamp. I have inserted this into the code as well. If it isn't what you want...
I thought I'd take a shot at this and the code that I wrote should work except that your query OnHand2 is trying to get its information from a query called OnHandQry and this query doesn't seem to exist. The following code will access the information if you can figure out where that query went...
I would do this in VBA. Simply put you create a text box on the form that your doing the calcuation in and link it to the record you want. Then perform your calculation and set the textbox value to the results. See below.
using VBA:
Sub Calc()
Dim Calc As Integer
Dim Val1 As Integer
Dim Val2...
It's been my experience that you should never design a database with multiple tables that are used to store basically the same information. Maybe there are times when you should do it but I've yet to come across one. With that said I'd say your first design is the way to go.
Joe
I have a large database that tracks Employee Training. On the Employee form I have an embedded OLE Excel Spreadsheet that gives a breakdown of their on the job training requirements. The Excel spreadsheet gives me a training status in percentage. I need to get the results from that percentage...