?
Solved

query error in access 2010 dao 3.6

Posted on 2016-09-27
5
Medium Priority
?
94 Views
Last Modified: 2016-10-16
I'm getting an error on a query on some machines, but not mine
dao reference 3.6

Hours Minutes: Format([inprogress_or_closed_at]-[OPENED_AT],"Short Time")

Could there be another way to write this query ?

error:
"function is not available in expressions in query expression"

Thanks
fordraiders
0
Comment
Question by:Fordraiders
  • 2
4 Comments
 
LVL 42

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 41818191
I've attached a database that will help you.  It has functions to work with dates.

The problem with what you are doing is that date fields represent a point in time.  They do not represent elapsed time which is what you are trying to calculate.
UsefulDateFunctions121218b.zip
2
 
LVL 53

Expert Comment

by:Gustav Brock
ID: 41818255
On those machines your application is missing a reference. Go to the code window, menu Tools, References and check that none is MISSING. If so, correct that.

Compile and save the application.

/gustav
1
 
LVL 3

Author Comment

by:Fordraiders
ID: 41843505
I have been on vacation.
0
 
LVL 3

Author Closing Comment

by:Fordraiders
ID: 41846132
sorry for the issue
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
This following write-up describes a different way to copy Lotus Notes Calendar to Outlook. Along with this, we will also learn the reason behind this NSF to PST migration. Users can prefer different procedures as per their convenience.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question