Recent content by martlaco

re: Calculate # of occurrences... Oddly enough, I had wondered about that.... It's running fine! Thanks so much for your help and patience in walking me through this. Much appreciated!!! Martin

re: Calculate # of occurrences... Thanks again for your (very quick!!) reply! I think I'm getting closer... Here's where I'm at... (btw, should have indicated I'm using Access 2000 - I'm assuming that does not affect things, but, just in case...) - pasted the code into a module (below the...

re: Calculate # of occurrences... Sorry for not getting back to you sooner, Bob - thanks very much for your reply. If you'd be able to, would you be able to walk me through how to use this (or is there some help file online that might guide me there)? I'm assuming this goes into a module...

Thought I'd be able to find out easily, but.. here I am... How can I query the number of occurrences of a string in a field, e.g.: if a name field has the text: Martin Lacoste how can I get it to tell me there are two "a"s in the field? I can use InStr to find one, and make a few more...