Format problem going from Access 2000 to Access97

[smileyx]

I was using Access2000 and had a calculating field as follows : <br>
=Format([Departure time]-[Arrival time],&quot;short time&quot<br>
<br>
This worked fine in 2000 and gave amount of time spent, however with the system converted to 97 to run on colleagues machines when the report is run it asks for Format Parameter value.<br>
<br>
What am I doing wrong or does 97 not recognise this command. If this is the case how should I get the &quot;time spent&quot; result.<br>
<br>
Thanks

 

[elizabeth]

Your syntax is OK for Access97. Sorry I can't be of more help than that.