dancerjodi: (Default)
dancerjodi ([personal profile] dancerjodi) wrote2009-07-02 03:23 pm
Entry tags:

Lag Function in MS Access?

Does anyone know how to get this kind of functionality http://help.pop.psu.edu/help-by-software-package/sas/lag-and-dif-functions in an MS Access query? Access will take some VB and SQL script, but I'm not able to get anything out of it using what I'm familiar with.

Thanks in advance! :)

[identity profile] leilaland.livejournal.com 2009-07-02 07:29 pm (UTC)(link)
Totally off topic, but THANK YOU!! Adam from Cat Country just called me. He's going to try to help me out with my band problem. We didn't want to ask because they just did the walk for us in May, but he said it was totally cool. Thank you thank you thank you!

[identity profile] dancer.livejournal.com 2009-07-02 07:31 pm (UTC)(link)
Adam is a great guy and knows a ton of people because of his role at the Radio Station, so I figured it couldn't hurt to poke him about it. Hopefully he can swing something for you. :)
ext_4429: (Default)

[identity profile] lensman.livejournal.com 2009-07-02 08:00 pm (UTC)(link)
I'm not sure but I think this link explains the VB script needed to do what you are looking for on the LAG function. (The answers should be viewable at the bottom of the page in Firefox, I think they get hidden in IE).

Hope this helps.
ext_4429: (Default)

[identity profile] lensman.livejournal.com 2009-07-02 08:10 pm (UTC)(link)
Hmm another Lag reference for MS Access that I came across that also looks like it might be related to what I think you are trying to do. The Time Series Functions...