UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Incremental Count, Access 2010    
 
   
JanRaven
post Jun 24 2019, 07:03 AM
Post#1



Posts: 9
Joined: 22-March 19



Hi everyone.

In my subform I have a column with part numbers [PN].
I also have a column with Coding [Coding] and using Expresion builder I created a formula that combines data from other fields to produce the coding (up to the dash).
I am stuck however with the final part, which is how to count each occurence of a particular PN.

In Excel this formula does the trick: COUNTIF($D$1:D1;D2)+1.

I was wondering if there is any equivalent in Access.

Coding | PN

RLC3522-1 | AC60000ST0L
RLC3711-2 | AC60000ST0L
RLC4227-3 | AC60000ST0L

ROT7720-1 | 71381512102
ROT7717-2 |71381512102

ROT8A22-1 | 71NG7131027
ROT8A22-2 | 71NG7131027
ROT8B05-3 | 71NG7131027
ROT9612-4 | 71NG7131027

Any help greatly appreciated.
Go to the top of the page
 
cheekybuddha
post Jun 24 2019, 07:14 AM
Post#2


UtterAccess VIP
Posts: 11,424
Joined: 6-December 03
From: Telegraph Hill


Grab a coffee and have a read here on the UA wiki

--------------------


Regards,

David Marten
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    23rd July 2019 - 01:58 AM