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!

Recent content by TornierIT

  1. TornierIT

    SQL INSERT or UPDATE Query Help

    I got it from another site: UPDATE @Surg_Type SET Surg_Type = CASE WHEN Measure.LRI = 1 AND Measure.TORIC = 1 THEN 'LRI+TORIC' WHEN Measure.LRI = 1 THEN 'LRI' WHEN Measure.TORIC = 1 THEN 'TORIC' ELSE 'Refraction' END FROM @Surg_Type Surg_Type INNER JOIN ( SELECT...
  2. TornierIT

    SQL INSERT or UPDATE Query Help

    This was going to be used in a stored procedure. As far as any future additions, if I see the code and it works correctly, I can add any future ones. I am just puzzled on how to make sure the correct Surgery Type gets put into the Surg_Type table. Here is the Hierarchy from lowest to highest...
  3. TornierIT

    SQL INSERT or UPDATE Query Help

    It remains refraction. That's the lowest in the hierarchy that the field can be.
  4. TornierIT

    SQL INSERT or UPDATE Query Help

    Thanks for the quick reply. So this will look for ALL the records in the measurement table and find the correct field value based on the above criteria? For Instance: Surg_Type Table Surgery_Num Surg_Type 00001 00002 00003 Measurement Table: srgID msmID...
  5. TornierIT

    SQL INSERT or UPDATE Query Help

    I am having difficulties wrapping my brain around this one. Still a newb when it comes to SQL. I created a table called "SURG_TYPE" that only has 2 fields (Surgery_Num, Surg_Type). I have populated this table with the Surgery Numbers but now I need to populate the "Surg_Type" from a separate...
  6. TornierIT

    Convert String to Number

    Figured it out.. I just put this in the subreport: ToText({report.id},"00") in ({?Pm-sqlalert.report}) But if there is a different way, i would like to know
  7. TornierIT

    Convert String to Number

    Using Crystal 9 and an access database, I am trying to split a field that can contain 1 to many values all separated by a comma. I think need to convert the values in this field to numbers and use it as a select criteria for a subreport FieldName: Report (String,155) some examples of values...
  8. TornierIT

    Formula Help: Running Total Formula

    If it matters to anyone else. here is my final formula: WhilePrintingRecords; NumberVar PreOpRef_RefCyc; NumberVar PreOpRef_RefCycCount; NumberVar PreOpRef_BiomK1; NumberVar PreOpRef_BiomK1Count; NumberVar PreOpRef_BiomK2; NumberVar PreOpRef_BiomK2Count; NumberVar PostOpRef_RefCyc; NumberVar...
  9. TornierIT

    Formula Help: Running Total Formula

    Disregard Lbass. Its been a long day for me. WORKED LIKE A CHARM Much appreciated
  10. TornierIT

    Formula Help: Running Total Formula

    HERE IT IS SO FAR.. CAN YOU PLEASE EXPLAIN THE "AND" AND SEMICOLON PART YOU MENTIONED: WhilePrintingRecords; NumberVar PreOpRef_RefCyc; NumberVar PreOpRef_RefCycCount; NumberVar PreOpRef_BiomK1; NumberVar PreOpRef_BiomK1Count; NumberVar PreOpRef_BiomK2; NumberVar PreOpRef_BiomK2Count...
  11. TornierIT

    Formula Help: Running Total Formula

    I am just trying to cut corners here, if I use this formula, it works fine, but I will need 6 formula fields for 6 criteria (with more in the future), so I am trying to cut it down to only 6 formula fields, with these IF statements." the is the formula I was talking about in this sentence...
  12. TornierIT

    Formula Help: Running Total Formula

    MY APOLOGIES: Yes, this is a 3-part Manual Running Total (I think Malcolm had the FAQ for it) Yes, i am using shared variables from a subreport which is placed in a group footer above this formula. I have used these many time when one condition is met, but now that I have multiple conditions...
  13. TornierIT

    Formula Help: Running Total Formula

    Same error message. I even removed all the other NumberVar's after it was declared
  14. TornierIT

    Formula Help: Running Total Formula

    I have been going cross-eyed looking at this and wanted a second set of eyes. I keep getting a "Boolean is required Here". This formula is the 2nd part of the 3-part running total and I wanted to include all the variable into one formula (there would be over 75 formulas if I have to break it...
See more

Part and Inventory Search

Back
Top