how can I

[macamarr]

I have a table that list the date, account# and the drivers name. I need to show the delivery percentage that a driver has to a given account. I am not sure if explained this correctly:

example:

2-02-02 John 1111
2-09-02 Adam 1111
2-16-02 John 1111
2-23-02 John 1111

I need the query to show for account 1111 John 75%
1111 Adam 25%

 

[LTunnicliffe]

The sure bet way to do this (there may be a better way) is to create three different queries.

1. Query1 Group by Name and Acct # and count the number of Acct # call this number of StopsNameDidAtAcct
2. Query2 Group by Acct # and count the number of Acct # call this TotalNumOfStopsAtAcct
3. Query3 uses both Query1 and Query2. Link the Acct # in both queries together and then take then take the StopsNameDidAtAcct / TotalNumOfStopsAtAcct

Like I said there is probably an easier way of doing this but this will work.

Hope this helps!