Calling function from query

M

Michelle

I am trying to call the HoursAndMinutes function that I got off the Microsoft
site from my Access 2003 query to calculate elapsed time but it treats it
like a variable and never runs the function. What am I doing wrong?

In query:
TimeInterval: HoursAndMinutes([ViewCreated]-[PromoteReview])
 
K

Ken Snell \(MVP\)

Post the code for the HoursAndMinutes function. What is the name of the
Module in which that function is placed?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA concatenate ranges into a new document 0
E-mails disapair from trash 0
Problem with SET & REF function 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Display weeks from a Milestone 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Call function from query 'Criteria' line. 11

Top