Combining two tables w/ Seleciton Formula

[B1naryPro]

I am using a Selection Formula in Visual basic, trying to concatenate two tables from sql server, but i am getting a run time error '13' type mismatch. here is the selection formula.

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"

if i take out the And "{caoactions.Followcheck=x", it works fine, so it looks to have a problem with the second table.

please help, appreciate it

JPBinary
MCSE, MCSA

 

[Madawc]

What data type is it? Does it match the data type of "x"

Madawc Williams
East Anglia, Great Britain

 

[B1naryPro]

it is a char data type.

JPBinary
MCSE, MCSA