I have created a report in Access that returns the same information as a pivot table I designed in Excel. In Excel, when you click on a count of an item, it opens a new worksheet that lists all the records that were counted.
What is the best way to replicate that in Access, so if they click on Item A, they will see datasheet for all the Item A items with details from the query records?
Report example:
ITEM-------------DUE-------------DONE
Item A------------16---------------9
I used Count function based on a query to get the totals
=Count([DUE A]) or =Count([DONE A])
Datasheet details example
NAME-------ITEM----------DUE--------DONE
Joe-------- Item A-------- 1/1/19 ---1/10/19
Jane------- Item A --------1/1/19
Many thanks for helping me understand the best way to design it.
What is the best way to replicate that in Access, so if they click on Item A, they will see datasheet for all the Item A items with details from the query records?
Report example:
ITEM-------------DUE-------------DONE
Item A------------16---------------9
I used Count function based on a query to get the totals
=Count([DUE A]) or =Count([DONE A])
Datasheet details example
NAME-------ITEM----------DUE--------DONE
Joe-------- Item A-------- 1/1/19 ---1/10/19
Jane------- Item A --------1/1/19
Many thanks for helping me understand the best way to design it.