Recent content by jmriddic

Hi all, I have 4 fields called presten1,presten2,presten3, and presten4. Since they denote a smilar type value the user wants to find the overall min/max for the fields as a whole.I am having a lot of trouble even trying to come up with a formula to compare each one with another in the...

Hi LB, Are you meaning are they part of the same record? yes, they are. Name seg#1 seg#2 seg#3 pre_sten1 pre_sten2 pre_sten3 Joe Blow 1 2 2 75 85 90 John Dow 1 3 5 80 84 82 And visualize post_sten being on the same row. On the...

Hi LB, It would probably work if I could show how the report is laid out as far as the table goes but I cannot attach the report. Yes, in this case the category(ie the segment_number field whehter be number,number2,number3 or number 4) would have to be part of the formula since they group the...

Hi LB, Lets see if I can explain. I have basically artery blockage(its for a cardiovas system) categories 1-8 which the formula you suggested to me help calculate the number of occurences of the category over 4 screens which explains the segment numbers 1-4 which hold the value of the category...

Hi LB and all, Your formula for me work. Thanks. Maybe you can help me with a related formula. The example I brought up before use the value 2. I have have other categories using the values 1-8 and the formula you suggested help me calcualte the number of occurences of that category in the...

Hi LB, Thanks for the help. its definitely working now. Might look u guys for some help on some other formulas in the report.

I tried this and now it expects a number after the second if numbervar x:=0; if isnull({v_cc_data.cc_segment_number}) then 0 else if{v_cc_data.cc_segment_number}="2" then x=x+1;

Hi, Would we not have to declare them first and how is X populated as well as the other fields. Thanks.

Hi all, The following formula is supposed to add up the number of times the following fields have a certain value. So if two of the fields have the value then the value of the field. I am not even getting a zero when testing this and I do have records that have the value in question. numbervar...

When I open my form with the tab control on it the scrollbar has scroll down and I can't see my tabs. How do I keep it at the top when I open my form. Somebody suggested API on one site. Page Focus does nothing for me. Please help!