troubleshooting Question

Count Multiple Fields - Crosstab -Access 2010

Avatar of Tanus Sacin
Tanus SacinFlag for United States of America asked on
Microsoft Access
5 Comments1 Solution274 ViewsLast Modified:
Hello There,

I have a Access DB that I use to control my assets.

Right now, I have a crosstab query that I can see what items are going to expire and the total of them  and I can see them on the following formats:

Item Type      Total             Year
Laptop                 50           2012

This is telling me that I have 50 laptop that I need to buy for 2012, so how can I add a price to my report? for example, I need to create a report that I show to my Financial Manager, so this is what I am looking for:

Item Type      Total             Year      Unit Price    Total
Laptop                 50           2012        1000          50000

I was able to get that working ( with a great help of ukerandi ) but now, is that I need to have multiple items with multiple prices on the same report...., look at the example:


Item Type      Total             Year      Unit Price    Total
Laptop                 50           2012        1000          50000
Computer              5          2012              50          2500


I have a form, so I want to add those values from the form, since those values are just to have an IDEA on how much the replacement of the equipment will cost, we dont need to keep the value store on a table or somewhere else....

Thank you!!

I have attached of copy of the working DB as a reference..
Database4-2.accdb
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 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 5 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