SQL server has this amazing set of functions (lag and lead). Unfortunately it is not available in Microsoft access, but I was wondering if anyone knows or has written a vba public function equivalent for lag and lead. The potential of lag and/or lead are so amazing that it actually surprised me that Microsoft access doesn't have it. Thank you for your time!