Search results

what do you mean group the managers in a query?

I have a report that is grouped by a few criteria, one of which is a multivalued field "manager". The report displays "purchase orders" grouped by "customer" and then again by "manager". some of the "purchase orders" have 2 "managers" and currently the grouping separates the 2 managers into 2...

i officially gave up. i made the text box where i was trying to resize the text twice as wide so it doesnt matter now. thanks for the efforts anyways

you might be able to do it by creating 2 hidden controls to initially hold the value 0, and writing a similar IIF statement that would go something along these lines IIF(Report.HasData, control +=1,) so that it adds one for each valid value. then divide by the control in the main set of IIF...

Thanks! don't forget to mark this as solved by using the thread tools menu! Derek

Glad I was able to help and that you figured it out. I'm relatively new to access and felt bad only asking questions, so having an answer is cool

I think for the second one you used IFF rather than IIF

you could probably accomplish this by using some code in an "event" without more detail i can't get specific on an answer

from what i can see you are missing the 0 portion of the argument. try this: (IIF([rptEmployEvaluationOperator subreport].[Report].[HasData], [rptEmployEvaluationOperator subreport].[Report]![OPTotal], 0) + IIF(Next report,field you want, 0))/2

ok so i got the DSum working using the following: =DSum("CountOfEmployees_EmpFull","POSummaryRates","POID=" & [POID]) but the debug staetments are still showing that [POSummaryAvgRate].[Report]![numEMP], where numEMP is the DSum is always 1 so the font size is still not changing. the numEMP...

since this Dsum is in a control in a subreport, how would i set the criteria for it to match the POID(purchase order number) from its source query with the main reports POID for grouping?

i changed the contents of numEMP to =DSum("CountOfEmployees_EmpFull","POSummaryRates") which gives me a count of 9 which is correct for the total across all 3 purchase orders, 1+1+7. now the font size on all 3 pages is size 6. now i just need to have it group by purchase order number and ill...

some of the odd behavior can be seen in my attachments

so after throwing in some debug.prints, its showing that [POSummaryAvgRate].[Report]![numEMP] is always 1 and fontsize is always 10 as i flip through the pages of the report. the last page of my report the numEMP should be 7

I will insert a message box after i finish this reply. I can tell the font size has been staying at 10 because i can visually see it across multiple pages of the report. As for the value of numEMP, i have 2 extra text boxes on my report that contain "=[POSummaryAvgRate].[Report]![numEMP]" both...

Text15 is in the POID Header section. On Format for the POID Header section is as follows: Option Compare Database Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) If [POSummaryAvgRate].[Report]![numEMP] = 5 Then Me.Text15.FontSize = 9 ElseIf...

On Format event is in the "POID Header" which is where the text box it should be styling is also located.

no luck there either, font size stays the same still.

The main report is called "ProjectSummaryReport" The subreport is called "POSummaryAvgRate" the subreport control containing the sum of employees is called "numEMP" The main report control im working with is "Text68"

this asks me to enter parameter value for numEMP