asked on

function is not available in expressions

i've run this in query in my computer
Year(DateDiff("d",[FBDATE],Date()))-1900 & " years"
problem is when i run this query in other computer it does not work, and a message is appear like this,
(function is not available in expressions in query "yeardiff: Year(DateDiff("d",[FBDATE],Date()))-1900 & " years"

matey18

what version of access are you developing in, and what version are you trying to run the query in please.

lowellton

ASKER

dear mately18,
i used access 2000 running on win98 and the other pc is also win98 and access 2000 also

SOLUTION

Zmey2

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

randycarpet

Check the References: Tools, References (in VBA Editor - ALT + F11) and make sure that your PC and the other PC's are identical.

ASKER CERTIFIED SOLUTION

Mike-Kieswetter

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nexusnation

Hi lowellton,
This question has been abandoned and needs to be finalized (109 days since last comment).

You can accept an answer, split the points, or get a refund. Go to
http://www.cityofangels.com/Experts/Closing.htm for information and options.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

nexusnation
EE Cleanup Volunteer for Microsoft Access

1William

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, split popints to Zmey2 and Mike-Kieswetter
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer