Recent content by AndersL

Now I have solved the problem, I did not use a Dlookup. Instead I did some looping that did the trick. Thanks for the help! This is the code i used: Set db = CurrentDb() Set Rst = db.OpenRecordset("GapAnalysis") Rst.MoveFirst hold_ID = Rst!ID hold_Count = 0 Do While Not Rst.EOF If...

What I basically want to do is to do a running sum over the laps. I want this for every driver. How do I show to you how my table looks in a good way? should I take a print screen and upload it here? Best Regards Anders

Anyone who has any ideas to solve this or any suggestions on another aproach to solve the problem? Best regards Anders

Yes that is correct, the reason for using access is that the data from the races are saved for numerous years in an access database to be able to look back in time to evaluate what happend last time we drove on this track. The whole database system is bases quite similar as you wrote but i didnt...

Oh, those explaining tables didnt turn out to good :D

Hello everybody! this is my first thread here so lets hope im doing this right :) I have been a passive "member" now for a couple of months but now i have run in to a problem who I have not solved yet (stuck on the same issue now for a couple of days). I think it is easy to solve but now i...

Hi Im Anders i guess that I can say that im more of a MATLAB guy but im now fighting with ms access :) So far ive learned alot from this forum and im hoping i will learn more now when im a member. //A