Hello,
I am useless with access and have been trying endlessly to modify a template.
For anyone good with Access can you take a look at this template
http://office.microsoft.com/en-us/templates/results.aspx?qu=inventory&av=my.zac140#ai:TC010206882|
What i want is a Asset/Inventory tracking database.
So delivery of equipment comes in and then its assigned and tracked to a person, when its assigned it subtracts from the stock that is held.
Problem with this template is its combined the transactions so if you look in inventory transaction table you will see it takes additons to stock and removals. I want to seperate this so you have a table that adds and the inventory transcations table to subtracks.
Anyone help? not sure how hard it would be...
I am useless with access and have been trying endlessly to modify a template.
For anyone good with Access can you take a look at this template
http://office.microsoft.com/en-us/templates/results.aspx?qu=inventory&av=my.zac140#ai:TC010206882|
What i want is a Asset/Inventory tracking database.
So delivery of equipment comes in and then its assigned and tracked to a person, when its assigned it subtracts from the stock that is held.
Problem with this template is its combined the transactions so if you look in inventory transaction table you will see it takes additons to stock and removals. I want to seperate this so you have a table that adds and the inventory transcations table to subtracks.
Anyone help? not sure how hard it would be...