Recent content by Sham

Thanks - that worked! :)

Boblarson - thanks but i want to count the number of IDs by title

Brian - it still doesn't work. I have other fields in my query - could this be the problem?

Hello! i am trying to sum the total of ID's by corporate titles in query. In the totals row i have selected 'count' in the ID column and 'sum' in the title column but this doesn't work. I tried the reverse and it also was no good :confused: Can anyone help - i'm sure its something simple thanks

hi - i've got a date question Is there a formula that can work out the number of years and months between 2 dates. For example 17-Jan-06 - 30/04/2007 = 1yr 4 months. is this possible. Once i've done this I can put them in year bandings i.e. <1yr, 2-3yr. Currently i'm doing this in Excel...

hi i've got a similar problem - i want to calculate the date difference between two dates in "yy-mm" format. I want to get the length of service so number of years and months between hire date and termination date. Can anyone help?

hi ripley, when i enter my field name it becomes a parameter

yes i want the results to show in years and months

its working! thx Keith now my next q what is the formula to get the length of service between dates in yy-mm format i.e 01/01/2006 - 31/05/2007

thanks Keith, however i get 'data type mismatch in criteria expression' error i have pasted in your formula (after amending the column headings) into the field column of my query. not sure where i've gone wrong?!

Hi, Is there anyone here who can help me with writing a formula in query to return results. Basically i have hire and rehire columns and i want my new column to have a formula to give me the most recent hire/rehire date. Please respond if u can help thx