Recent content by David Bailey

Count of Months - Thanks Thanks, works brilliantly

Hello Does anybody know a formula that will enable me to count the number of months between two dates. I am sure it must be very easy, but the help menu is no help. Thanks

Thanks for your response Any chance of an example of the use of StrConv to convert a field from upper case to title case? Much appreciated

I have a field that contains a peoples full names, first name and surname in the same field (not my design) and need to build a query that extracts the left most word (being the surname). Obviously the with the LEFT function you have to specify the number of letters but this may vary Any ideas...

I am trying to write a query to convert text in a field from upper case to title case. I can easily convert text into lowercase using the lcase function or if I wanted upper case using the ucase function, but there does not appear to be a function to convert to title case. i.e first letter of a...