 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / June 2006Counting specific text fields
I looked thru the postings and see similar questions, but am still hoping someone will spell out the answer for my questions. Users are selecting county from a drop-down box - "Chas", "Dor", "Other". In my report, I want to total how many times each of these counties were selected. Can someone be very specific in showing me how to write this out & where I need to put it in my report? Thank you. On the report footer you can create three text boxes, in each text box Control source specify the count for each country Text 1 =Sum(IIf([Country] = "Chas",1,0) Text 2 =Sum(IIf([Country] = "Dor",1,0) Text 3 =Sum(IIf([Country] = "Other",1,0)  SignatureGood Luck BS"D > I looked thru the postings and see similar questions, but am still hoping > someone will spell out the answer for my questions. [quoted text clipped - 5 lines] > > Thank you. I did try putting that formula in the footer, but it's literally reading it as text, not as a formula?? > On the report footer you can create three text boxes, in each text box > Control source specify the count for each country [quoted text clipped - 17 lines] > > > > Thank you. It isn't clear whether the counts are the only information on the report or if you want this summary information in the report header or footer. If this is just a part/summary of information elsewhere in your report, I would use a subreport that is based on a totals query. SignatureDuane Hookom MS Access MVP >I looked thru the postings and see similar questions, but am still hoping > someone will spell out the answer for my questions. [quoted text clipped - 6 lines] > > Thank you. The counts for county are only part of the report. For each record, some fields are # entries - generally 1 or 0 (meaning yes or no). The county field is one of the few text entries. I'm having trouble pulling the summary values all together for these types of fields. Thanks. > It isn't clear whether the counts are the only information on the report or > if you want this summary information in the report header or footer. If this [quoted text clipped - 11 lines] > > > > Thank you. Did you try create a subreport based on a totals query as I suggested? SignatureDuane Hookom MS Access MVP > The counts for county are only part of the report. For each record, some > fields are # entries - generally 1 or 0 (meaning yes or no). The county [quoted text clipped - 23 lines] >> > >> > Thank you. I'm trying it right now, but am not entirely sure I know what I'm doing... > Did you try create a subreport based on a totals query as I suggested? > > The counts for county are only part of the report. For each record, some [quoted text clipped - 24 lines] > >> > > >> > Thank you. The key is to - create a totals query that groups by County and performs counts or whatever on other fields to calculate what you want to see in your report. - Then create a report based on this totals query. Keep in mind that Page Headers and Page Footers won't display in a subreport. - Insert the subreport into the appropriate section of your main report. - You may need to remove any link master child properties of the subreport control SignatureDuane Hookom MS Access MVP > I'm trying it right now, but am not entirely sure I know what I'm doing... > [quoted text clipped - 32 lines] >> >> > >> >> > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.