help with list calculation
Is there a way to write this list function to place "and" prior to the last field?
Example (This is what the calculation does at this time):
apple, milk, cherry
I would like it to do:
apple, milk and cherry
This is my calculation
Substitute ( List ( field) ; ¶ ; ", ")