Search results

This problem was solved in another thread http://www.access-programmers.co.uk/forums/showthread.php?t=258485&highlight=billing

This problem is solved in another thread http://www.access-programmers.co.uk/forums/showthread.php?t=258485&highlight=billing

RV Could you share the sample database on the forum or send it to me? Thanks

Re: Overlapping dates (days) This works (adapted files from this thread). Simple but I hope it helps someone.

I have a need to find overlapping date ranges and the date overlap submitted by EMP seems to work just fine. I have a need to find the number of days that the ranges overlap. How could I query for that?

Geotch - this is genius- thanks. I have gone through the steps to see how you did this. Qry0_delete Temp Deletes all row information except for the header from tbl_tmp (I am not sure why it deletes the whole row when just autoID is referenced?) Qry1_Main Is joining information from Transfers...

http://allenbrowne.com/subquery-01.html#AnotherRecord Could someone please post an attachment that shows the information in this link applied as a database. I have tried to do this but am unsure as to how to apply it? Thanks

Thanks again for the help. This is what I see each step doing: qryStep1MaxID – Is finding the max TransSub for each tool (Col- ToolNum : MaxOfTransSub qryStep2PreviousID – Is finding the Previous Transfer of each tool. qryStep3maxIDdetails- Find Last Transfer Date for Each Tool Number. (Uses...

Hi Geotch – Thanks for the post. I have been playing with the attachment that you posted and learned about sub queries. I haven’t not figured out how to do what I need yet. The information I want to sort is not sequential. If you look at my attachment you will see that I actually am using 2...

Hello: I am trying to use a query to find the previous record of a transaction and provide an additional field that computes the difference in the dates in days. (The days from TransferID 23 to TransferID 24) TransferID Job Number Tool Number TranferDate DaysOnRent 22 1...

Thanks to those that have added to this thread. I have attached my work to this point. I think what I have is functional for transferring tools but I could still use some help getting to the monthly billing portion of the work. I will need to be able to figure days rent on each tool at each job...

I work for a commercial construction company. We have several different types of contracts with several different criteria. Some allow rental fees for any tool over 1 value level and 1 uses another etc. Billing is done on a monthly basis. We mostly supply basic power tools mostly under $2000.00...

Fixed rental periods for tools are not a norm for the business and even if they were it would be rare to that the date did not change. Most tools will be out for months at a time. At least in our situation. So each month every job needs to be billed for the tools on the job for as many days as...

I will try this again. On my last attachment I exported only the Object that I thought were needed and pulled out my personal information. I did not enter enough information to show what was happening. I have added multiple transfer dates for the same tool and would expect to find the day...

Attached is most of what I have so far. It works but I am not sure how to track dates that tools are Transferred from a specific job. I will need to use that information to compute days rent for specific months. Ideas or similar database examples would be appreciated. Thank you.

The tool may not always be rented out but it is always somewhere - even if at the warehouse. The tool may go straight from one jobsite to another without getting to the warehouse at all. It seems to me that an end date would require 2 transfers instead of one. There may be a work around scheme...

Hi, I am building a Tool Rental Data Base and need help with tracking length of time a tool is on a job and billing for it. I have my tables built and have Forms and Queries that Transfer a tool to a job. That is as far as I have gotten. I need to build a monthly billing system etc The...

Hi - Thanks for this post and responses - they have been very helpful. I have attempted to apply the same procedure to a tool rental database but the computations are not working. I am just getting a 0 result to every record. Can anyone show me corrections to my code: Public Function...

I am building a tool rental data base. I have places a delete button on my Transfer form so the operator can erase any mistake that he/she just made on a Transfer ticket. When I push the button I get an error message saying that I can't delete the record because it is associated with 2 tables. I...

I am glad to be a part of this forum as I have found some help here and hoping for more. I have always been intrigued with Access but never really got very far with it. I have taken a lot of online training but have found that real world building of my project is far more complicated than the...