"Not working" means what - error message, wrong results, nothing happens?
Post the code for the getTimeElapsed function.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
This is a VBA custom function. What you show is calling the function. It is not the function code.
The procedure must be placed in a general code module so the query can find it.
Apparently, the function does not exist in your db, at least not where the query can find it.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
how can Calculate Number of Years, Months and Days between 2 dates... plz help me,,,
Why did you post a link to this thread?
Where did you learn about this function? You need the VBA code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.