Dennis, to the best of my knowledge the entire syntax is incorrect: the FROM clause is in the wrong place.=A0 I can not be within any of the pa= renthesis.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 --- On Mon, 2/2/09, Dennis McGrath <[email protected]> wrote: From: Dennis McGrath <[email protected]> Subject: [RBASE-L] - RE: Adding a calculation to a report To: "RBASE-L Mailing List" <[email protected]> Date: Monday, February 2, 2009, 8:38 AM SELECT ((SUM(CALLSHET.TOTMNHRS FROM Memberbasics))/60) WHERE… You needed parenthesis around the entire expression Dennis McGrath From: [email protected] [mailto: [email protected] ] On Behalf Of Steve Holanov Sent: Saturday, January 31, 2009 1:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Adding a calculation to a report Buddy: I did look at DB Calc but there were very few options for calculations, mainly a few built items such as Sum and Count. Here is my proposed SQL: SELECT (SUM(CALLSHET.TOTMNHRS FROM Memberbasics))/60 where TOTMNHRS is my column that is totaled (actually minutes per row) CALLSHET is the table I need to divide the TOTMNHRS by 60 to get hours since the data is actually in minutes. Thanks, Steve ----- Original Message ----- From: Walker, Buddy To: RBASE-L Mailing List Sent: Saturday, January 31, 2009 1:57 PM Subject: [RBASE-L] - RE: Adding a calculation to a report Steve Have you looked at DB Calc. If you post your SQL statement it would help with answers or suggestions. Buddy From: [email protected] [mailto: [email protected] ] On Behalf Of Steve Holanov Sent: Saturday, January 31, 2009 1:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Adding a calculation to a report I have two questions about adding a calculation to a report: 1. When I create a new variable how do I add it to the report form? Either in a header/footer or preferably at the end of the table data in the report body? 2. I can easily define the calculation I want in SQL but cannot get the expression builder to accept my SQL string. Any tips for this would be appreciated. Thanks in advance, Steve Holanov Shrewsbury First Aid Squad Shrewsbury, NJ 07702
