Forum Discussion
LAG function
Hello, I do have a problem using the LAG function in a View. I use: LAG(Process_Time,1) OVER (ORDER BY Process_Time) Problem is: As soon as I hit the retutn button it delets "OVER (ORDER BY Pro...
Hi Olafhelper,
thanks for your advice. If entered directly as text it works but it is rather slow. I am using Access as a front end I may as well run this table through a little program code and calculate the time diffference, probably it is quicker this way. I will try and compare.
However, your advice was good. Thanks.
Regards
Peter
Peter62270 , in MS Access you can use "Pass-Through" queries to pass it directly to SQL Server instead that Access process the query.