How can I write this cell-referenced Excel formula in VBA to use in MS Access: (b2-a1) -
this simple calculation in excel stumped on how within access using 2 fields in table in different records. 1 application have needs find difference between operation stoptime , next starttime. help appreciated. new vba.
sub sample() dim starttime date dim endtime date starttime = time '''your code endtime = time debug.print datediff("n", starttime, endtime) ' difference in minutes end sub
vba
No comments:
Post a Comment