Count the Nulls in between occurrences of a specific value in a table?

**frescia** · 03-11-2019, 02:23 AM

I want to count the zeros or Nulls between the occurrences of the letter 'A'. Can this be done in a query?

Click image for larger version.

Name: cnt1.png
Views: 11
Size: 26.8 KB
ID: 37785

Thank you in advance.

**isladogs** · 03-11-2019, 02:45 AM

You don't have any nulls. Do you want to count the zeroes?
Could there ever be any gaps in ID values due to deleted records or can that field be used for counting?

**frescia** · 03-11-2019, 05:24 AM

Hi Isla,

Thank you for replying.. Yes I want to count the zeros and no, there are no deleted records, but a new record is added weekly.

**isladogs** · 03-11-2019, 09:47 AM

Its made a bit more difficult by having not A at the start or end. No time to look at it now. Hopefully someone else will offer a solution in the meantime

**frescia** · 03-11-2019, 12:14 PM

Originally Posted by isladogs

Its made a bit more difficult by having not A at the start or end. No time to look at it now. Hopefully someone else will offer a solution in the meantime

it is a challenging one

, thank you for your attention anyway.

Count the Nulls in between occurrences of a specific value in a table?

Thread Tools

Count the Nulls in between occurrences of a specific value in a table?

Count the Nulls in between occurrences of a specific value in a table?

Similar Threads

Count specific day between two date

Rank the records in MS ACCESS according to the occurrence in table.

Specific Record Count

in a rare occurrence of generosity by me ...

Show Only One Occurrence of a Record

Tags for this Thread

Posting Permissions