Search results for query: *

Hiya, I am creating a rental form for a colleague. They want pull-down boxes for Month, Date, and Year for the delivery and collection of an item. Then they want the form to automatically calculate the number of days an item was on hire. 1.How do I combine the data from the month, date, and...

I want to create a table or query where, based on the calendar month, a set fuel price will be called up. I created the table with the monthly prices as just one entry per month--which defaults to the 1st of the month. When I run the autolookup query, the fuel prices are generated, but *only*...

I have a report that calculates charges based on the amount of time a piece of equipment was on hire. This works by subtracting an on-hire time from an off-hire time to get an interval. Of course, a bug comes up whenever a job is still on-hire, i.e. no off-hire time is entered in the database...

Hi, I have created an Access 2000 database for work. It has the usual stuff, and one key form, which is a revenue calculator. I had not compacted my database for 2 weeks. When I did (a couple days ago) the all-important form now comes up with repeated error messages that say, 'run-time error...

I am creating a program for work that essentially calculates various charges and displays them on a form. A couple charges are time-performance based. e.g. As a rental company, we agree to deliver the goods within 3.5 hours. If our delivery time exceeds that, then it qualifies as a late charge...