Microsoft Access Update Query Needed For Similar Excel Function Countif(B$1:B1,B1)
$10-30 USD
Terminado
Publicado hace casi 6 años
$10-30 USD
Pagado a la entrega
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.
Hello, dear sir!
I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality!
From the Access, of course, familiar.
Give me a chance to show what I can do!
Hi, there
I hope all's well with you.
I see you'r looking for a developer proficient in Ms Access/VB.
I'm Ms Access/VB/SQL/Excel programmer since 1997.
Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects.
I'll do your current Ms Access project very professionally and on time.
Thank you for your consideration.
Zura
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.