adrianzazugmail.com Posted May 12, 2018 Share Posted May 12, 2018 Hi, Good night, I have problems compare two differents fields in two tables, first in table1 I have the field, days off, this field is string and the information appeer this: SD.In the second table, the field is double and the information appeer this: 67.I tryed whit a variable and I can compare the two fields with a if/else, (some this: if DL=71, else LM=12... ) but the value of the variable is not saved, when I filter in the query, the variable not work. I tried with a subreport to pass the value of the variable to a parameter in the subreport, but no save the information. My question is: I can declare the variable in the query for to filter whit a WHERE? (WHERE $V!{CONDITION} <> 12)PART OF MY CODESELECT * FROM TABLE1 PART OF MY CODE TABLE2 FIELDX=FIELDYWHERE FIELDX<>FIELDYORDER BY NAME ASC Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now