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

$10-30 USD

Complété

Publié

il y a presque 6 ans

$10-30 USD

Payé lors de la livraison

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

N° de projet : 17280072

Concernant le projet

4 propositions

Projet à distance

Actif à il y a 6 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@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 en 1 jour

0,0

(0 commentaires)

0,0

4 freelances proposent en moyenne $57 USD pour ce travail

@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 en 1 jour

5,0

(192 commentaires)

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 en 2 jours

4,6

(54 commentaires)

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 en 1 jour