Search results for query: *

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

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

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

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

I'm a newbie, so be gentle ;>) I have a form with a Group Header on which I print a field called txtTitle, txtTitle.visible-true. This is determined based on whether or not the field txtbold is true or false. If txtbold is true, txtTitle is visible. On the same form I have a detail area...

I posted the following to the Tek-Tips forum for Novell Groupwise last week, and haven't gotten a response. Since it involves Access, perhaps someone on this forum can assist me. I need to save certain emails and copy/paste them into an Access database. I've done the "Save As", but the only...

I need to save certain emails and copy/paste them into an Access database. I've done the "Save As", only option is to save the email as a .doc, which doesn't include every recipient, including CC and BC. Is there a way to save email and include ALL recipients and attachments so I can paste...

Thanks to foolio12, my page footer dilemma got solved yesterday, now I have another situation. Not to self: Seems that whenever I include another subreport something else happens. Oh well, live and learn :>) One of the 9 subreports that I've included in my Main report is using a Page Header...

I have a main report that calls several subreports. Among other problems, the page footers do not print in the subreports, although they print when running the reports individually. I've searched this forum (and others) and cannot find any explanation/solution for this. Can anyone help...

FYI: I'm using Access 2000. I've created a "Master Report" that prints 3 subreports(eventually there will be 9 subreports). Everything is 'almost' okay until Report 3 prints. Then, despite trying all combinations of the Force New Page on each of the 3 reports, the Report Header from Report...

I need to print a report, but eliminate blank fields. For example, currently the report prints: Name Address 1 Address 2 ----------->Prints even if it is blank City, State ZipCode How can I print as follows when Address 2 is blank: Name Address 1 City, State Zip...

Would someone please recommend several Access 2002 manuals/books I should purchase as I'm learning? I've visited several bookstores but am hesitant to make a purchase without someone recommending some books before I spend the cash. I've read/used a college textbook/tutorial to get me started...