Field counter

[gmaster]

Hi! I'm trying to write a vba code that cycles on selected fields of a table and counts how many records fill them (i.e. it has to skip and not count the empty cells)...is it possible?

Edit: trying to be more specific, i have a table with a dozen column and i wanna perform the count on three of them, then sum the three values in order to obtain the total number of filled cells of those three columns

[June7]

Why VBA? Try an aggregate query:

SELECT Count(Field1) AS Count1, Count(Field2) AS Count2, Count(Field3) AS Count3 FROM tablename;

[gmaster]

Thanks, it works!