Search results for query: *

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...

No go. Column heading still printing literally instead of as 05AMOUNT. :-\

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...

I need to do in WebFocus what I know as an outer join in Access. Can anyone help me with this JOIN syntax? Thanks, Mary E.

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...