Count function trouble

  • Thread starter Slez via AccessMonster.com
  • Start date
S

Slez via AccessMonster.com

I'm trying to add a group level to a report so that I can add a Count
Function, but when I add the intended group header or footer, values in some
of my calculated controls are altered. My report is structured like this:

Group: =DatePart("q",[BidDate]) - header and footer set to Yes
Group: =DatePart("ww",[BidDate]) - header and footer set to Yes
Group: BidDate - header and footer set to No...just used for sorting
ascending
Group: BidNumber - header and footer set to Yes but not visible

I want to add a group level for the field ProjectID between the groups
BidDate and BidNumber so that I can provide a count of how many different
ProjectID's there are per week, quarter, and in the report footer. I can add
the ProjectID group to the "Sorting and Grouping" window, but as soon as I
set either header or footer to Yes, no matter where ProjectID falls, it
totally alters the values in my calculated controls. I viewed a number of
previous posts on this topic, but wasn't able to successfully resolve this.
Any suggestions as to what might cause this behavior?
Thanks
Slez
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
Sorting/Grouping question on report 2
trouble with "quarterly" report 0
Need some PWA help 0
A03 - count in report footer gives me #Error? 0
Report Group Footer DLookUp 0
How to save a PDF with header that extends to edge of page? 3
sorting and grouping issue 2

Top