HI, I am in dire need of help. I attempted to do this myself and I just can't wrap my brain around it. Can someone please help me? I would be very grateful.
I am trying to display on a form the average number of lines/records per hour that a person is adding to the database. After hearing some ideas from people and trying to get it work myself I've come to realize that I suck at this. I thought I had a handle on it and I kind of did 4 years ago, when I created the inventory program that we use, but I don't know what to do. What I though I'd do was this.
Trying to work with Dfirst and DLast I'd subtract the time of the most recent record from the time of the first record entered and then divide the number of records to display the average per hour in a text box. I have NO idea how to do this or even where to place the VBA code. Can some please help me with this code and where to place it? I really, really need help here. Thanks VERY much for any help that you can provide. I really do appreciate it. :banghead:
I am trying to display on a form the average number of lines/records per hour that a person is adding to the database. After hearing some ideas from people and trying to get it work myself I've come to realize that I suck at this. I thought I had a handle on it and I kind of did 4 years ago, when I created the inventory program that we use, but I don't know what to do. What I though I'd do was this.
Trying to work with Dfirst and DLast I'd subtract the time of the most recent record from the time of the first record entered and then divide the number of records to display the average per hour in a text box. I have NO idea how to do this or even where to place the VBA code. Can some please help me with this code and where to place it? I really, really need help here. Thanks VERY much for any help that you can provide. I really do appreciate it. :banghead: