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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.