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], "short time")<br>
<br>
In 2000 this will give me the time between the 2 fields, however in 97 this just returns...
I have created a report in Access which is A4 sized. When I save as a snapshot file and then open the saved file it only fills a quater of the A4 sheet in Snapshot Viewer. Why??? and how can I stop it.<br>
<br>
To check out the snapshot viewer I used the database wizard in access and created a...
I was using Access2000 and had a calculating field as follows : <br>
=Format([Departure time]-[Arrival time],"short time")<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...
I am attempting to produce a customer call report system.<br>
<br>
The idea being whenever a customer visit is made details of the visit are logged and a report produced at the end of the week.Each call is stored as a record.<br>
<br>
One piece of data the form asks for is "mileage on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.