missing library in access 97

[smileyx]

I am using Access2000. I have written a database which is also being used by Access 97 users.<br>
<br>
I am having a proble with<br>
= Format ([dep time] - [arrive time], &quot;short time&quot<br>
<br>
In 2000 this will give me the time between the 2 fields, however in 97 this just returns #name.<br>
<br>
Any ideas, could this be a missing library?<br>
<br>
Thanks

 

[DougP]

Well start at the begining.<br>
try changing the &quot;Short time&quot; to &quot;hh:nn&quot;<br>
I suppose you made sure you have those functions<br>
&quot;Dep time&quot; and &quot;Arrive time&quot; in Access '97 Modules TAB.<br>
Those are functions in your program that someone or some company created and not built in eihter version of Access.<br>
<br>
Or when you say &quot;Missing Library&quot; are those functions in an .OCX you got somewhere?<br>

 

[elizabeth]

See Help in Access 2000 on &quot;#Name&quot; - subtitle &quot;some functions display the error #Name. It is pointing you to Msowcf.dll .