Microsoft Access Update Query Needed For Similar Excel Function Countif(B$1:B1,B1)

$10-30 USD

Completed

Posted

almost 6 years ago

$10-30 USD

Paid on delivery

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.

Microsoft Access

Project ID: 17280072

About the project

4 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@dariomelman

I'm new in freelancer.com, thats why I have no calification and I'm charging you so little, so people can know how I work. Thanks!

$15 USD in 1 day

0.0

(0 reviews)

0.0

4 freelancers are bidding on average $57 USD for this job

@VladimirLilenko

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!

$30 USD in 1 day

5.0

(192 reviews)

6.8

@zu02

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

$111 USD in 2 days

4.6

(54 reviews)

6.1

@liangjongai

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.

$70 USD in 1 day