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! :)