Recent content by s_m_chamberlain

I am trying to concatenate if that's the right phrase a string and a currency value to form a sentance, but can't seem to retain the currency formatting. I'm sure this didn't used to be a problem, but it seems to be now? For example I have a field called "Total Due" and I am trying to create an...

Thanks very much RV - that worked an absolute treat! :D

Thanks I'll give that a go.

Hi, I have a membership database I'm working on and the problem I'm tearing what's left of my hair out over is this: If the date of joining the club is <= 15th of that month then the renewal date is 1st of that same month in the following year. However, if the date of joining the club is >15th...