I am working on a report and this error has me stumped. error invalid use of Escape character with Like operator 716
These are the report vars 1 : DATE : PH : vdatecon = date_con in tran_hist where (custnum = custnum and tr_date = txdate) 3 : TEXT : PH : vdiag1 = diagnum1 in ptdiag where (custnum = custnum and date_con = .vdatecon) 7 : ERROR : PH : vICDA1 = ICDAnum in Diagnos where (DIA_CODE = .vdiag1) The rows of data in the table fail the #1 var but I didn't think that would cause this? There are no Like operators anywhere I can find Also when I try to preview or run the report I get an error about spdate not found but I do not have that column located on the report on in the view. Anything else I should look for? Thanks Marc
