Date calculations showing #ERROR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I've done some date calculations in my query in the design view. Formula as follows
Duration: Year(Date()) - Year(start_date())

This query is the record source for my form. When i open in Office 2003 or Office 2000 in some computers, the value for Duration is showing properly, but on some computers using Office 2000 or Office 2003, #ERROR is displayed as the value for Duration.

Could anyone tell me what could be the cause of this discrepancy in how the calculations is showing on the same version of MS Office?

Thanks!
yann
 
Yann

Sounds like one/more of the References has gone MISSING. Access
occasionally loses a pointer to a Reference. To check, and resolve, open a
code module. Click Tools|References. Note which Reference has "MISSING"
pre-pended. Uncheck those, click Save. Open the References back up and
re-check the ones you unchecked. Save again. Recompile.

Good luck

Jeff Boyce
<Access MVP>
 
Hi Yann
You might also check the formatting of the
clock/calender on the machines that are giving the error.
It may be different than the machine on which the code ran
okay

Hope This Helps
 
Back
Top