I need a formula/query in Access that will give me the same result as the attached excel file for column B. This would be in an update query where B would be the calculated field. In excel, the formula would be Countif(B$2:B2,B2) and would drag down so that the result would show the number of times that field has been seen above. I have millions of records so need a formula to produce this exact result.
Được trao cho:
6 freelancer đang chào giá trung bình $47 cho công việc này
I can work for you. I'm interested in your project. I've an experience of works like ms access with various queries. Ping me any time to discuss about this project.