ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combine a Dlookup with DMAX function (https://www.excelbanter.com/excel-programming/349423-combine-dlookup-dmax-function.html)

ca1358

Combine a Dlookup with DMAX function
 
Commit = DLookup(Nz(DMax("commit", "commit", "[commit] = " _
& Forms!Form![Commit], 0) + 1))
--
ca1358


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com