Search results for query: *

That's perfect! You have been a great help! You definately get a star! Thanx again!

Nope that don't work...it's needs to somehow be something like =sum([age] where [sex]='female') / Sum(Abs([Sex]="Female")) Any suggestions?

I'm sorry...the record source for the report is a query that has all the necessary fields for the report. The query also has "Between [forms]![reports_form]![txtbdate] And [forms]![reports_form]![txtedate]" as the criteria for the [intake date]. The summary part of the report in the...

I was thinking that the criteria for each total was too complicated for the control source. For example I didn't know that you could do a sum of a filtered criteria. I am still having trouble with this one though. If you can walk me through this one then all my troubles will be fixed. Here...

Well...yes and no. You see the user wants to be able to set the date range for the report and some of the totals can get rather complicated. For example for the total of inactive clients: 'Total inactive clients Cmd1.CommandText = "select count([pid]) from profiles where [intake date]...

Sure...for example one of the totals that I do is the total of males and here is the code that I use. This is just one of the thirteen totals that is at the end of the report. Thanx! 'Number of males Cmd1.CommandText = "select count([sex]) from profiles where [sex]='male' and [intake...

Hello everyone! My problem is that I am am creating a report that has some complicated totals. So I created a set of code that opens the report, then performs a set of sql queries to find each total. This procedure works very well if the report is greater than one page. However, if the page...