troubleshooting Question

Count fields Query - Access 2010

Avatar of Tanus Sacin
Tanus SacinFlag for United States of America asked on
Microsoft AccessExchangeSQL
51 Comments1 Solution621 ViewsLast Modified:
Hello there,

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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 51 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 51 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros