Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: marye
  • Order by date
  1. marye

    variable in fieldname

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

    variable in fieldname

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

    variable in fieldname

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

    variable in fieldname

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

    variable in fieldname

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

    outer join

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

    setting a list of variables

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

    setting a list of variables

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

Part and Inventory Search

Back
Top