Recent content by WWRA

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

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

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

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

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

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

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!

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

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

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

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.

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.

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

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

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