The ParseWord () function.

[LOUISBUHAGIAR54]

I would like to get the first word from a field. I have made some research and found that the ParseWord () function is the best for this purpose.

However when I include it in a query to get the first word I get an error message ' Undefined function'.

Can I get some enlightenment please on this issue and why this function is not working for me ? I am using access 2007.

Many thanks.


LouisB

 

[plog]

Access has built-in functions (Mid(), Date(), Int()) that you can use without writing the code for. The ParseWord() function is not built-in, you need to create it. I assume you are talking about this ParseWord() function (http://allenbrowne.com/func-10.html)

What you do is copy the function and paste it into a module, save the module and then your query should work.

 

[LOUISBUHAGIAR54]

To Plog:


Many thanks for your reply with the valuable information. Did not realise. Thought the ParseWord was an inbuilt function.

I will incoporate it in my Code.

Louis B.