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

Calculating hours on a timeclock form 7
Time Function 3
Totaling Time In a Report 4
sumif function in Access query, possible? 3
Calling Parameterized Query Using SQL Syntax 3
Calculate No. Days between two dates 4
Problem w/Date time function 2
Use Function in Query problem 6

Top