Count Need help ASP

[ScottF]

I made a select query with a field call sales numeric and add a field in the query cal total to add the sale. It work but it will not add the last record in the output. Why

 

[jfgambit]

Scott:

I'd like to help, but what you wrote is kind of cryptic...can you be a bit more specific as to what you have and what you are trying to accomplish??

 

[ScottF]

reply

I have a table that has 2 fields "Rep Number" ,"Sale" and added a field in the query call Total where it does a count function on the "Sale" field. I made a select query so I can add up the sale field. The query I made add up the sale field except for the last record. There three record which total 7 sales. The first two have 2 sale a piece and the last record has 3 sales. So the count is only added up the first two record and not the last record. I hope this help you understand and thanks for repling.

 

[ScottF]

SQL

SELECT DISTINCTROW RepMasterSheet.[Rep Number], Sum(RepMasterSheet.Sale) AS [Sum Of Sale], Count(RepMasterSheet.Sale) AS Total
FROM RepMasterSheet
GROUP BY RepMasterSheet.[Rep Number];

 

[ScottF]

Never Mind

I know what happen now it just telling me how many record each Rep has. I need to add the sale on the report and I'm not sure how to do that.

 

[jfgambit]

My suggestion would be to create a query that pulls the line items detail, add that to your report and on the fotter of the report add a textbox with =Sum([Sale]) for the total sales.