I am working on a database with Access 2010, and I need to create a report of the amount of computers, laptops monitors etc, etc that we have.
The DB have control of everything that we have, but each monitor or laptop or pc its assigned to a user, so we can what belongs to what, so , so far so good, but now that I need to create a report of the total equipment that we have I am facing a wall....
so on my table I got this field:
Asset <- ( Here I can choose for, Workstation, Monitor)
AssetType <- ( Here I chose for laptop, PC,ThinClient ,etc)
so basically I need to pick something from the Asset Field then I can pick from the assettype,
So how can run a report where I can have the total of "Laptops" or "PC"??
also, I have another filed where I keep the date of purchase and when the warranty expire, the field name are:
DoP ( for Date of Purchase)
WE ( for Warranty Expire)
So, how can I accomplish the following:
1.- Have a report with all the total "AssetType"
2.- Have a report with All the Total "AssetType" base on the WE? let say I want to see everyitng that is going to expire in 2012, so I can run the report and see it.
thanks in Advanced.