Thanks to both of you for this response, you've saved my sanity, having spent
half the day trying to find this info in the Access Help !! Why wouldn't
this info be available in the main Help when you can use these functions in a
bog standard query ????
Again, many thanks
Serena