Search results for query: *

Thank you - you have just answered a question that has plauged me for YEARS of developing financial pro-formas! Thank you!

Sorry about reviving an old thread - I realized shortly thereafter that I should have started a new one. However, copy, paste, transpose does not do the trick! It pastes the functions (=IF(Pay_Num<>"",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,"") into the new spread sheet

I am new to this forumn and apologize if I am posting this question incorrectly... I have a Excel loan amortization table (out of box template supplied with Excel) that has interest payments indicated in a column. G18 is the interest for March 06, G19 is the interest for April 06, etc. On a...

I am new to this forumn and apologize if I am posting this question incorrectly... I have a Excel loan amortization table (out of box template supplied with Excel) that has interest payments indicated in a column. G18 is the interest for March 06, G19 is the interest for April 06, etc. On a...

I figured it out... I created the Y and N fields, sum'd them in the group footer, then created the Pct sum field with the sum'd fields crystal created... Got it... Great... Thank you! Peace

I can't seem to get the correct ( ) or { } correct in the PctyesQ4 formula... The @Q4Y and @Q4N I understand exactly... When I double click the formula fields to insert them into the last formula Crystal places the {} around the formula names and I am getting them confused with your ()...

My SQL table has 25 fields - Q1, Q2, Q3, etc. each field representing a question on a customer service survey. The field is populated with either a 'Yes' or 'No'. I normally group these reports by locationcode (a field) and then by associate (LastRSA). I would like to create a report that says...

That still doesn't show any records...

I use the FlexQuarters QODBC driver and it works GREAT! The better news is, the next release of QuickBooks (Pro or Enterprise... I am not sure) is going to include this ODBC driver for free!

I have a SQL file that has the field email. In QUERY ANALYZER the following statement returns 528 rows: select * from customerlist where email is null and lastvisit >='10/08/2005' But in Crystal Reports 9, the following statement in my record selection formula: {CustomerList.LASTVISIT} in...