Working in SQL and am trying to figure out how to do this.

I've had to create "formula's" to change memo fields to strings so that they can be grouped and sorted.

One of these "grouped" fields is sorted by client. In the information contained I have survey type, submit date, and some other things.

I need to create a formula that tells me if each grouped client has both survey types.

In my head the formula goes like this:

If "patient group" contains "survey type 1" and "submit date" and "survey type 2" and "submit date" then true else false

I am new at this and these formula's are either simpler than you think or more complicated.

This is what I tried after other numerous others:

If GroupName ({@Patient}) =
{lime_survey_27974.27974X51X1763}"1" & {lime_survey_27974.submitdate} and
{lime_survey_27974.27974X51X1763}"2" & {lime_survey_27974.submitdate} then "True"

and no, this didn't work. I'm trying.

Now for my next question... how do I count my trues? I can't group/subtotal or select that field. I've converted the true false to True =1 else 0, and now it's a number, but I still can't group/subtotal or select just the "Trues"


//Flag_1
if {lime_survey_27974.27974X51X1763}="1" then 1

//Flag_2
if {lime_survey_27974.27974X51X1763}="2" then 1

if sum ({@Flag_1}, {@Patient})>0 and sum ({@Flag_2}, {@Patient})>0 then "True"

if {@True Total}="True" then 1 else 0

What am I not doing right. I've tried running totals, trying to do a parameter... anything I could think of and now I have to ask for help.

I so tried.

Shaking my head on that one, I was so close (and yet so far) from that formula in the Running Totals. THANK YOU so much.