Accessing the value of a control in the group footer for computation

[Great Macoy]

In the group footer of my report, I have placed three
controls,

GroupPhyCount: =sum(phy_count)
GroupRecCount: =Rec_Count
GroupDiscrepancy: =GroupPhyCount-GroupRecCount

*If you will ask me why GroupRecCount is not the sum of
the column, its because the value in every group does not
change, it simply shows the recorded count and definitely
for each same item it will be the same value no matter how
many physical counts are entered. One more thing, the
grouping is a per item grouping because during MANUAL
INVENTORY, there could be more than one PHYSICAL COUNT
ENTRIES for a single item.

NOW, Is there anybody who can share his knowledge how to
access the values of GroupPhyCount and GroupRecCount so
that I can compute their totals in the PAGE FOOTER, and
REPORT FOOTER. Remember that in the REPORT FOOTER, I
can't just simply say "=sum(Rec_Count)" because the value
in the GROUP FOOTER is not actually the sum but simply
REC_COUNT, the value of the last record in the group which
is uniform to all the items in the group and must not be
added-up.

 

[Eric Butts [MSFT]]

Hi,

Have you seen the solutions in the following articles:

http://support.microsoft.com/default.aspx?scid=kb;en-us;207763

http://support.microsoft.com/default.aspx?scid=kb;en-us;216311

http://support.microsoft.com/default.aspx?scid=kb;en-us;208850

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Great Macoy" <[email protected]>
| Sender: "Great Macoy" <[email protected]>
| Subject: Accessing the value of a control in the group footer for
computation
| Date: Thu, 29 Apr 2004 22:31:24 -0700
| Lines: 26
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQudGDLInPhzfnIT9iYATtZg/w1zg==
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.reports:137093
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.reports
|
| In the group footer of my report, I have placed three
| controls,
|
| GroupPhyCount: =sum(phy_count)
| GroupRecCount: =Rec_Count
| GroupDiscrepancy: =GroupPhyCount-GroupRecCount
|
| *If you will ask me why GroupRecCount is not the sum of
| the column, its because the value in every group does not
| change, it simply shows the recorded count and definitely
| for each same item it will be the same value no matter how
| many physical counts are entered. One more thing, the
| grouping is a per item grouping because during MANUAL
| INVENTORY, there could be more than one PHYSICAL COUNT
| ENTRIES for a single item.
|
| NOW, Is there anybody who can share his knowledge how to
| access the values of GroupPhyCount and GroupRecCount so
| that I can compute their totals in the PAGE FOOTER, and
| REPORT FOOTER. Remember that in the REPORT FOOTER, I
| can't just simply say "=sum(Rec_Count)" because the value
| in the GROUP FOOTER is not actually the sum but simply
| REC_COUNT, the value of the last record in the group which
| is uniform to all the items in the group and must not be
| added-up.
|
|