Recent content by dsthomson

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.