Oh! This worked great!
Now, I only have one other quirk to ask about (right now :-) ) for this particular situation...
What if I wanted to concat a field value and a word instead of a system or typed variable and a word? Say I have a field in my MFD (YEAR) whose value is the year. I tried...
Then maybe I don't fully understand your suggestion. I can make the concat symbol work in a DEFINE when creating a value, but I thought you were suggesting I could use it in the PRINT statement (which is where I'd *like* to use it). From your earlier post...
PRINT AMOUNT AS &THISMONTH|AMOUNT...
When I try to apply the concat symbol with no spaces between the 2 fieldnames, it seems to think the | is part of the fieldname (i.e. LASTYEAR|AMOUNT appears literally as that). When I try to separate the | from the 2 fieldnames with a space (as you might in a DEFINE), it thinks the first...
I'd like to use a variable (actually, the results of another field) as part of a fieldname for a column heading. In other words, I have a field, THISYEAR, the value of which will always be the current year (therefore, THISYEAR currently results in "05"). So, I'd like the have the column...
Hm, that's interestng. I originally had the ORs, but my manual seems to indicate that I should use commas instead. Of course, the only manual I have is one for 7.0. Plus, if our school is still on the 80 char software, this feature won't work for me anyway.
Thanks for the response & I'll try...
Hello folks,
I'm trying to check multiple fields against a group of values. Instead of saying
IF (FIELD1 EQ 'BLAH1' OR 'BLAH2' OR 'BLAH3') OR
(FIELD2 EQ 'BLAH1' OR 'BLAH2' OR 'BLAH3') OR
(FIELD3...
I'd like to say
IF (FIELD1 EQ 'ck list of values in the variable') OR
(FIELD2 EQ 'ck...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.