<div>
So the query returns no records?<br />
<br />
If this is the case, have you verified that there are records in the vote table that have a corresponding record in the racerinfo table based on the voteod and ID columns.
</div>


So the query returns no records?

If this is the case, have you verified that there are records in the vote table that have a corresponding record in the racerinfo table based on the voteod and ID columns.

<div>
no only for percentage column. &nbsp; i know i have many votes<br />
<br />
can u look to see if query looks ok
</div>


no only for percentage column.   i know i have many votes

can u look to see if query looks ok

<div>
TSQL is not my strongest point so I may not be the best to say, but it looks OK to me. 
</div>


TSQL is not my strongest point so I may not be the best to say, but it looks OK to me.

<div>
<div class="content wysiwyg-content">
this query is working perfectly in access. &nbsp;i created the table same structure in sql server 2005 and it wont show the percentages. &nbsp;it says 0 as results<br />
<br />
SELECT TOP 6 Count(vote.voteid) AS ['Count Of Teams'], racerinfo.racername, (((Count(vote.voteid))/(se<wbr />lect count(voteid) from vote))*100) AS TotalPercentage<br />
FROM vote, racerinfo<br />
WHERE (((vote.voteid)=[racerinfo<wbr />].[ID]))<br />
GROUP BY racerinfo.racername, vote.voteid<br />
ORDER BY Count(vote.voteid) DESC
</div>
</div>


this query is working perfectly in access.  i created the table same structure in sql server 2005 and it wont show the percentages.  it says 0 as results

SELECT TOP 6 Count(vote.voteid) AS ['Count Of Teams'], racerinfo.racername, (((Count(vote.voteid))/(select count(voteid) from vote))*100) AS TotalPercentage
FROM vote, racerinfo
WHERE (((vote.voteid)=[racerinfo].[ID]))
GROUP BY racerinfo.racername, vote.voteid
ORDER BY Count(vote.voteid) DESC

voting query not working anymore

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.