Search results

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

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...