VB and Crystal Selection Formula

[B1naryPro]

I currently have the following formula passing a date variable to a crystal report. Here is the code for that:

rptFollowUp.SelectionFormula = "{CAO.DateReceived} in Date(" & Left(strControl, 4) & "," & Mid(strControl, 5, 2) & "," & Right(strControl, 2) & &quot to Date(" & Left(strControl2, 4) & ", " & Mid(strControl2, 5, 2) & "," & Right(strControl2, 2) & &quot"

Now I want to add another variable to this selection formula from another table. I want to add this formula rptFollowUp.SelectionFormula = "{CAOActions.Followcheck} = " & "'x'"


How would i go about adding this string to the current selectionfomula. Appreciate any help thanks

JPBinary
MCSE, MCSA

 

[synapsevampire]

Try:

"{CAO.DateReceived} in Date(" & Left(strControl, 4) & "," & Mid(strControl, 5, 2) & "," & Right(strControl, 2) & &quot to Date(" & Left(strControl2, 4) & ", " & Mid(strControl2, 5, 2) & "," & Right(strControl2, 2) & &quot"
"and {CAOActions.Followcheck} = " & "'x'""

-k

 

[B1naryPro]

Didn't work: Here is the formula do you see anything wrong??

rptFollowUp.SelectionFormula = "{CAO.DateReceived} in Date(" & Left(strControl, 4) & "," & Mid(strControl, 5, 2) & "," & Right(strControl, 2) & &quot to Date(" & Left(strControl2, 4) & ", " & Mid(strControl2, 5, 2) & "," & Right(strControl2, 2) & &quot" And "{CaoActions.FollowCheck}= " & "'x'"

thanks

JPBinary
MCSE, MCSA

 

[synapsevampire]

Perhaps the "'x'"

Try just the "{CaoActions.FollowCheck}= " & "'x'"

Is it supposed to be the literal value X, or a passed value?

What about:

"{CaoActions.FollowCheck}= x"

-k

 

[B1naryPro]

The value that it supposed to get is the field from a sql table. I only want to show records where the fields = x.

Thanks

JPBinary
MCSE, MCSA