Missing Data in Query Output

[Tim]

Hi,

I use Access queries to help me rank the performance of bookrunners for
market share purposes. I keep running into a problem where some data is
missing from the output. For example, the query would return the following:


# of
Industry Bookrunner Volume Rank Share(%) Deals
Industry Total
C&H ABC 100 2 25% 5
400
C&H DEF 80 3 20% 2
400
C&H IKJ 60 4 15% 3
400
C&H LMN 40 5 10% 4
400

when it should have return the following:


# of
Industry Bookrunner Volume Rank Share(%) Deals
Industry Total
C&H OPQ 120 1 30% 6
400
C&H ABC 100 2 25% 5
400
C&H DEF 80 3 20% 2
400
C&H IKJ 60 4 15% 3
400
C&H LMN 40 5 10% 4
400

The data that is missing is different each time I run the query. Does
anyone know what would cause these errors and how to fix it? Does it matter
if the query is based on a table or another query? Below is the SQL for the
query whose output is presented above:

SELECT T.Industry, T.Bookrunner, T.Volume, (select Count(*)+1 FROM
[Incomplete League Tables] AS M Where M.Industry=T.Industry and
M.Volume>T.Volume) AS Rank, T.[Share(%)], T.[# of Deals], T.[Industry Total]
FROM [Incomplete League Tables] AS T
WHERE (((T.Industry) = [Type the Industry you want to see]))
ORDER BY T.Industry, T.Volume DESC;

I would appriciate any advice you can give me.