Search results for query: *

That's it! Works a treat, many thanks! Andy Wing Local Government - Systems Officer England

I'm trying to format a font to go red if criteria are met but I've got lost with this one Does the following formula make sense to anybody who can see my mistake? I think I need brackets somewhere but I don't really know! if {databasefield1} in [7, 8, 9, 10, 11] and {databasefield2} > 90 then...

Thank you Mike (mbarron) that works a treat, there's no way that I would have got there! Brilliant! Andy Wing Local Government - Systems Administrator England

In Excel 2000 April 1, 2005 - March 10, 2005 = 22 I want this to display the 22 as 3 weeks 1 day(s) I think that makes sense! Is this easy? Andy Wing Local Government - Systems Administrator England

Thanks Gerry I was trying to count the number of boxes checked. I can count the boxes with {=count(check1,check3,check3)} But not just the checked boxes. For what I'm doing a macro is inappropriate as the users of the form would not be experienced users. Many thanks anyway. All the best...

What formula do I need in a word table to count the checked checkboxes in the column above? I must have tried every way but the right way! The document will be a protected form and the checkboxes bookmarked Check1 Check2 etc. Microsoft Word 2000 Any help gratefully received. Andy Andy Wing...

Many thanks dgillz That works well PS Extra thanks, your reply was posted within four minutes and it was just right first time!!! Andy Wing Local Government - Systems Administrator England

I can manage just the one field if {myfield} = "peter" then red else nocolor But how do I get multiples of the same in CR7 so that peter prints in red, paul prints in blue, dave prints in green etc.? Andy Wing Local Government - Systems Administrator England

I've searched the tek-tips archive for help with this question and found a similar question hoping to convert Minutes into Days Hours and Minutes, ie 4000 minutes = 2d, 18h, 40m MalcomW gave a good response ToText({{Minutes}}\(24*60),0) + 'd, ' + ToText((({Minutes}\60) Mod 24),0) + 'h, ' +...

Im reporting on premises that have been visited and graded A to F. My problem is that most premises have been visited more than once and have multiple entries. How can I select just the worst graded (A is worst) entries and disregard duplicate address. Crystal 7 Any brief starting points would...