Search results for query: *

I have a report with several supreports feeding into the main page of the report. Looks similar to this: Headings Category Count1 Count2 Total Enrolled 2 3 5 Removed 1 2 3 Then it jumps down several lines Carried in...

I have never tried this before and it may be a lot simpler than it appears. I want to make a combo box on a Form called MakeMonthSelect. I want the combo box selected value to populate five text boxes which won't be visible. The value in these five text boxes would be the criteria in the...

[3401] is just a numeric text field for a branch location of an office. I should have made my example more generic. What I failed to do was implement the Link Child/Master fields. I did download the article for future use. Thanks Eric Akerson

MainReport1 RecordSource = JPETbl_OM_Crosstab Subreport1 SourceObject = Report.JPCTbl_OM_Crosstab Subreport 2 SourceObject=Report.JSETbl_OM_Crosstab Subreport 3 SourceObject=Report.JSCTbl_OM_Crosstab Using an UNbound Text Box as a calc control I would like to subtract subreport1.Field...

I got desperate and did pay an Access consultant for the solution to my particular problem. The answer is CountCategory: IIf(Count([Category]) Is Null,0,Count([category])) The Total line of the crosstab for Count Category is Expression and the Crosstab line is Value. As you can see I haven't...

Sorry all but so far none of the suggestions have worked although it is intersting to see all the variations of the IIF IsNull statements. I will struggle on unless one of the forum experts has an idea where I am going wrong. Thanks to everybody for their help and suggestions.

So you were able to get your zeros to show for those columns that had no values?

I am trying to get a crosstab to count the number of text values in a field but even if I use the NZ function I cannot get any zeros to show. The Column headings show properly but those without any values are entirely blank. Where do you insert the NZ function in the criteria line with an IIF...

OK, next question. How do you get it to list zeros in the columns where there are no values? Does your crosstab query do this now?