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 derfloh 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: *

  1. Abslag

    scheduling CR 8.5

    Thanks synapse - for the info and the leads.
  2. Abslag

    scheduling CR 8.5

    Is it possible to Schedule a report to run at a given time and write to a specified file in CR 8.5 or is that only a feature of newer versions????? [ponder]
  3. Abslag

    Conditional summing with multiple contacts

    I am guessing because you have contact info you are pulling address/contact data from your customer master and joining that information with your payment history and then summing. So if there are 3 contacts all with the same customer number then it will join the payment history to all 3 and...
  4. Abslag

    custom formula add decimal places

    PDQBach- The difference between my above example of the "as is" at .02 hours per unit and "to be" of .0166 is 17%. Each of these units will be multiplied by 1,000's or 10,000's creating something more than "irrelevance". With the majority of the hours per unit being in the low digits, the net...
  5. Abslag

    custom formula add decimal places

    Using Ms Project 2002 I set up a custom formula in Number format, it all seems to work fine but I just need it to go deeper than 2 decimal places. Can anyone suggest a way to add decimal places? My formula looks like this (an "if" to avoid the annoying #Error with the Div/0 scenario) (Number 3=...
  6. Abslag

    INSTR Question

    Beilstwh, A valid point. In my position I have all the permission I need to retrieve data from the tables. Just none that would permit me to put data in the tables so I am not able to create the data. Thanks Anyway
  7. Abslag

    INSTR Question

    Santa, I think for what I am doing the hardcoded version will be perfect (even though it is longer). Thank you so much. You have a gift-[moroni 10]
  8. Abslag

    INSTR Question

    Right now I am trying to find the simplest way whether it is INSTR/SUBSTR or something else. I am open for any suggestions. Thanks in advance
  9. Abslag

    INSTR Question

    Hello All, I am trying to do an INSTR (unless someone has a better suggestion) The reference field combines several values that I need to isolate SELECT MS.IDENTITY, MS.INVOICE_NO, MS.CODE_A, MS.REFERENCE FROM IFSAPP.MAN_SUPP_INVOICE_POSTINGS MS WHERE MS.CODE_A IN ('5050','5051')...
  10. Abslag

    date convert

    Lewisp, I knew it was simple, but it had me going in circles. Thanks a ton. [rockband]
  11. Abslag

    date convert

    I have a field that contains date/time info but I need to convert it to a legible date time format. It is formatted like '20051206135428' and I would like for it to read 12-06-2005 01:54.28 pm (mm-dd-yyyy hh:mi:ss) or I could even drop the time and say mm-dd-yyyy. Whichever is simpler. Any...
  12. Abslag

    Drill Down in CR8.5 help

    lbass, It worked! You are BRILLIANT! Thank you
  13. Abslag

    Drill Down in CR8.5 help

    CR Verson 8.5 I am struggling with the Drill Down Headers. When I get to the 2nd Drill down i can't get the headers to work like I would hope. I am trying to get the title info over the detail section of drill down (2nd drill) without having it show over every result Maybe someone can help I...
  14. Abslag

    search and extract portion of description

    Thanx Engi, I worked great. Much appreciated!! [orientalbow]
  15. Abslag

    search and extract portion of description

    Thank you engineer2100, good stuff and I am half way there, I just need to be able to tell it to stop at the comma -1. Any other help on how I can do that?
  16. Abslag

    search and extract portion of description

    I am trying to 'extract' if that is the correct word, a portion of a description for a field, please see example. here's my simple statement: select hla.LOG_ID, to_char(hl.TIME_STAMP,'mm-dd-yy')Chg_Date, history_log_api.Get_Description(hla.log_id)Part_Desc, hla.OLD_VALUE...
  17. Abslag

    Get Current Year

    Gracias, I knew it was something simple Thanks for your help[unclesam]
  18. Abslag

    Get Current Year

    This is a newby question, but can anyone tell me how to get the current year? There are simple ones like CURRENTDATE which shows today's date, but how do I isolate the year from the current date?[roll2]
  19. Abslag

    Min Function

    djbjr, Thanks for the input, yours even looks simpler. I have already finished the report and the performance is quite good but gratefully the code is there for any other users that might happen upon this thread. **********[elk]**********
  20. Abslag

    User Defined Selection in Oracle 9i SQL

    Does my question make sense above?[elvis]

Part and Inventory Search

Back
Top