totals but only if 4 digits

[Chimp8471]

i need to total some data, but only if the code contains 4 digits.

by this i mean.

Code --> A101 ----> Occur 35
Code --> A101A ----> Occur 1
Code --> A101B ----> Occur 5
Code --> A101C ----> Occur 3
Code --> A101D ----> Occur 5
Code --> A101E ----> Occur 5
Code --> A101F ----> Occur 5

the total i need to be displayed is 24....

you will see that the first code only has 3 digits in the code...

Can this be done? if so how please

 

[Ron_dK]

You might try this :

Create a query and add a field e.g. New: New: (Len(

)-1)
and set the criteria =4
The output of this field will give you : 4.
On your form make a hidden field for New
Now you can sum the occur for all codes with <3 digits.

GL, Ron