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 Chriss Miller 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 WWRA

  1. WWRA

    Calculating a person's age

    Thanks for everyone's help in solving my dilemma with calculating a person's age. Building on everyone's suggestions, I finally solved my problem with the following code: TO_CHAR(FLOOR(MONTHS_BETWEEN(SYSDATE,Birthdate)/12)) I now get the correct age without a decimal point. As a newbie to...
  2. WWRA

    Calculating a person's age

    hilfy, Thx for the suggestion. The whole number I'm getting now is correct; however I'm still getting a decimal. For example, birthdate 21-DEC-1951 returns age 52.99, based on SYSDATE of 17-DEC-2004. Much better than I had, at least the 52 is correct. According to my Discoverer Handbook...
  3. WWRA

    Calculating a person's age

    Sem, Thanks for the suggestion. Being new to Discoverer, I was unaware of a Months_Between function. I'll give it a try. Also, the leap years dilemma is something I'm seeking help to resolve. I suspect some of the Discoverer gurus on this forum have already figured a way to accurately...
  4. WWRA

    Calculating a person's age

    Me again,,,the Discoverer newbie. I'm trying to determine a person's age using the following code: ( TRUNC(SYSDATE) - TRUNC(Birthdate) )/365 Two problems with this formula: 1. Birthdate of 25-May-1951, the age displays as 53.60. I need to display only 53. 2...
  5. WWRA

    Concatenation Question

    Many thanks to lewisp & Gardezi....by using your suggestions I got it to work.
  6. WWRA

    Concatenation Question

    Despite all my searches and using my Discoverer Handbook, I can't get the following concatenation to work as desired: CONCAT(Last Name,First Name) The problem is how can I get a space between the last name and the first name using concatenation? I've tried numerous things, no luck. TIA...
  7. WWRA

    Group By & Having problem

    rac2, thanks for the insight & suggestions. I'll use your ideas and see if they work. Stay tuned, this could get interesting ;>) Seriously, I really appreciate your taking the time to respond. Being new at this SQL stuff has proven to be quite a challenge. I can use all the help I can get!
  8. WWRA

    Group By & Having problem

    I tried to "search" on this forum, however the "search" function is currently not available. I'm very new to SQL, so please bear with me. The code below gives this result: LWIA Participants 00 1 However, if I remove the Having statement, I get LWIA 00 through 13, which...
  9. WWRA

    Visible.True causes double spacing on report

    dhookom & hymn, I gave both of you a star! Building on your suggestions, I've finally solved my print problem. THANKS! for your help.
  10. WWRA

    Visible.True causes double spacing on report

    dhookom & hymn, Thx for these great ideas. I'll try these asap and let you know how it goes. If you think of anything else, please let me know. :>)
  11. WWRA

    Visible.True causes double spacing on report

    dhookom, Thx for the suggestions. But, still no luck. I'm really hoping someone can help me solve this. Otherwise, I'll have to start over and change tables,logic, etc to get the report fixed. Again, thx for your help.
  12. WWRA

    Visible-False causes extra line on form

    Thanks for your help, Randy. I apologize for bothering you and others for the Forms Forum with a Report problem. I'll take your advice and post on the Reports Forum.
  13. WWRA

    Visible.True causes double spacing on report

    Report problem, see script & description of problem below, please. The problem seems to be with the txtTitle field. Is there any way to have a visible=false not allow for the space to print the field. The problem occurs in the GroupHeader0 section. Even though I put txtTitle.visible=False, it...
  14. WWRA

    Visible-False causes extra line on form

    Randy, First let me apologize, still trying to get the names down...obviously not doing a good job at it. This is actually a report, not a form (sorry). The problem occurs in the GroupHeader0 section. Even though I put txtTitle.visible=False, it still makes room for the txtTitle on the...
  15. WWRA

    Visible-False causes extra line on form

    Hi Randy, txtTitle.visible=True txtTitle.visible=false
See more

Part and Inventory Search

Back
Top