Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Fareng
-
Top 20 query problem
I was able to come up with a fix for the problem. When reviewing the Output I noticed that the qty that I was sorting on changed at record 19 and didn't change again until record 47. I added a hidden column with the sum of qty before that Material Number and did a sort on both of these fields...- Fareng
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
Top 20 query problem
I created another query to and did a top 20 on that and it appeared to work. I am using this data to crate a pareto chart so the order is critical. When I add the descending order to the query I get 47 records instead of the 20. I went back on tried this on the original code and the same...- Fareng
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Top 20 query problem
It is grabbing all 47 records and not limiting the list to the top 20- Fareng
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Top 20 query problem
Top 20 query problem I am having problems with a top 20 query pulling more that 20 records. Here is the code SELECT TOP 20 [Total Failure Pareto - Step 1].strMaterial_Num, Sum([Total Failure Pareto - Step 1].dblQty) AS dblQty, [Exclude Material From Pareto Chart].Exclude_Material_No FROM...- Fareng
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
