Hi Folks,
First time poster to any Access forum...nice to meet you all and look forward to working together with you all! :-)
I'm not new to Access, started using it back in 2003, but fell away from it for a number of years and just recently picked it back up and am struggling through learning 2016...love all the improvements!
I'm having an issue with one of my reports not behaving as I want it to and hope that you folks could help nudge me in the right direction.
In the attached image, Image1, you will see the furniture report as it is now. Each line represents a specific room although no room name or number is visible in the report. That is because we only want the totals of these pieces of furniture to show in this report.
In the database, there are 5 rooms that have C-01 chairs and each room has 30 chairs, 15 Ineligible and 15 Eligible, as you can see in the image. "Hide Duplicates" is set to "Yes" for ItemNo, Qty Ineligible and Qty Eligible, which is why they are not showing in the image. When I "Hide Duplicates" for the other fields, they will hide but the lines still appear.
What I would like to do his have only one line for each piece of furniture showing the totals of all items.
So for this report is should be,
ItemID=C-01- Qty Ineligible=75- Qty Eligible=75- Product Description= Poly Classroom chair....- Contract Price= $69.30- Manufacturer= KI- Model No.=IW413- State Contract=16SX0190- Cost Ineligible=$5,197.50- Cost Eligible=$5,197.50
Then 2nd line would be,
ItemID=C-02- Qty Ineligible=75- Qty Eligible=75- Product Description= Poly Classroom chair....- Contract Price= $70.40- Manufacturer= KI- Model No.=IW415- State Contract=16SX0190- Cost Ineligible=$5,280.00- Cost Eligible=$$5,280.00
Thanks in advance for your much need help!
Don
In this case the quantities happen to be the same.