I have a data table below, I would like to create a query to produce a result table like below, with count and percentage, using MS Access Query. I am unable to create this.
Name Alex Alex Bob Bob Roger Tim
Below result table
Name Count Percentage Alex 2 33% Bob 2 33% Roger 1 16.6% Tim 1 16.6%