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    
post Jun 24 2019, 07:03 AM

Posts: 11
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
post Jun 24 2019, 07:14 AM

UtterAccess Moderator
Posts: 13,120
Joined: 6-December 03
From: Telegraph Hill

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



David Marten
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    6th August 2020 - 04:08 PM