From: Peter Stone on 27 Jan 2010 00:02 No it can't be done in a query and there is no vb function. But Graham Seach wrote one that does the job: See "A More Complete DateDiff Function" at http://www.accessmvp.com/djsteele/Diff2Dates.html With that module installed, this is the function on the control source of my text box: =Diff2Dates("md",Date(),[UpdateNext]) Peter
|
Pages: 1 Prev: crosstab Next: Expression Builder query with zero amounts |