Recent content by Voyager48

Taking a snapshot of the report does not provide the detail of selection I need. dhookom, the blank mdb idea sounds promising. I do like idea of external date import. I will try both. Thanks.

That will require that both computers be able to share through the network. We will give that a try. Thank you for the information

We tried the export function but that only produced a report in results not the report formate. We both have the copies of the same database tables and queries that the report is based on we wanted to save the time of recreating the report.

I need to copy an access report format from one computer to another without copying the total database. I am trying to prevent having to recreate a long established report that is currently on my bosses computer that he wants me to send out. We have tried export but that only products an Excel...

I am trying to make a query that will give me the total engine hrs a truck was used during a 6 mo. period, to get a refund of part of the fuel tax. An Access database table that holds meter reading for trucks,mileage, engine hours, PTO hours. I need to develop a query that will subtract the jan...

Yes, I think a flag on the retired truck would work. The truck records do have a retirement date available. Would this require storing the last miles driven number or could I just have the program go back one month until a positive result is obtained?

The Formula is Present Month Odometer reading minus previous month Odometer reading.

I am trying to create a query and a report that will produce a current month miles driven and YTD miles driven for a division. The problem is how do I calculate YTD miles driven when a vehicle is sold but I want to count the miles driven in the division's YTD total. I'm creating monthly total...