Search results for query: *

whoops ver 9.2 thanx for that will check out yor link Ian --- Paintball is not a game : it's a way of life ---

Hi everyone, These two should be easy really I have a formaula that makes a field one or zero depending on wot another field is. I then sum this item using a group total. I have 3 of these altogether, one counting all, and the other two the specific items. I then have a couple of formula's that...

thanx 2 all have replied - v helpful - i can see this crystal programming not being quite as forgiving as VBA - oh well - another language to learn - wot fun. Cheer again Ian --- Paintball is not a game : it's a way of life ---

That worked a treat - i'll figure out treating null values - just a very strange thing to do for a formula to do if not true to ignore - never mind - i'm learning every day. Thanx wcburton. --- Paintball is not a game : it's a way of life ---

oh, i forgot if data is e.g F41,F42,F9,F5 i.e all fields are populated, then I DO get a result of 2, but I need it all the time. cheers Ian

I have a problem with a standard formula using if then - basically it won't display the ELSE part of the formula: if {SPE0304.T1} = "F3" or {SPE0304.T2} = "F3" or {SPE0304.T3} = "F3" or {SPE0304.T4} = "F3" then 1 else 2; sample data: F3,F41...