Printable View
hello
I want to implement the formula for the "Number of Repetitions" and "Sum of Count" columns in Access (in a query or table)
(For example, AA003 is repeated four times, showing 4 in one column and numbered from one to four in the other column)
I am attaching their files
Thank you very much
I want to generate the numbers in the given columns according to the Excel file with vba or ....Quote:
Originally Posted by habib100
Numbering rows in Access query is a common topic. Start with review of http://allenbrowne.com/ranking.html.
Getting both stats in query will require a subquery. Build a query that does the aggregate (GROUP BY) count and join this query to table in another query that does the row numbering.
Otherwise, build a report to produce this output using Sorting & Grouping features along with summary calcs and textbox properties. No VBA and no complex queries.