I am designing a database where I want to keep track of assets (i.e an excavator) and the number of days it has been at a certain location (a project).
For this I have made a table with an autonumber Field (recno), an assetID and a FromDate.
I have also a Field for ToDate, but may be I can pull that date from when it is moved to the next project.
We have a project called "Available" to which an asset will be allocated whenever it is not at a certain project.
Soehow i have to either find a way to insert the ToDate into the record for that asset with the highest recno, or find a way to make a View to make up the number of days.
Then I wil calculate internal prices for internal invoicing.
I am sure there are some tricks to kepp track of any history like this.
Maybe I also want to put the latest location into my Asset Table, but I haven't figured it out yet how to insert a value into another table like this.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Parma2015
Hi!
I am designing a database where I want to keep track of assets (i.e an excavator) and the number of days it has been at a certain location (a project).
For this I have made a table with an autonumber Field (recno), an assetID and a FromDate.
I have also a Field for ToDate, but may be I can pull that date from when it is moved to the next project.
We have a project called "Available" to which an asset will be allocated whenever it is not at a certain project.
Soehow i have to either find a way to insert the ToDate into the record for that asset with the highest recno, or find a way to make a View to make up the number of days.
Then I wil calculate internal prices for internal invoicing.
I am sure there are some tricks to kepp track of any history like this.
Maybe I also want to put the latest location into my Asset Table, but I haven't figured it out yet how to insert a value into another table like this.
Regards
Jan H Arntzen
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.