Hello Everyone I'm new to Access
I want to create a Queries that generate percentage for example
I have a table that have many companies and each company is assign a fruit
com fruit
001 apple
002 orange
003 apple
004 apple
005 apple
how can I generate a query that first column will list the type of fruit and the second will list the percentage compare to the sum of all the fruit. for example:
Fruit..... percentage
apple...... 80%
Orange... 20%
Thanks