Re: Not Suming Duplicates

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you for your reply. I tried what you posted and it does not work.
When I view my report a box pops up saying
"Enter Parameter Value"
txtPostingsRS
When I hit ok, it shows my report but no total in the report footer. Any
help is appreciated. Thanks

Mark


"Allen Browne" wrote:

Create a group header for Postings.
(Sorting And Grouping box, on the View menu.)

In this section, add a control with these properties:
Control Source =[Postings]
Running Sum Over All
Visible No
Name txtPostingsRS

Now add another text box to the Report Footer section, and set its Control
Source to:
=[txtPostingsRS]

The Running Sum property causes it to accumulate the value once for the
grouping. The final text box then displays the correct total.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mark Jackson" <MarkJackson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AEFF5212-094A-4F00-8135-515ED888E5D1@xxxxxxxxxxxxxxxx

I have a report that is bound to a query. In this query I am using 3
different tables. Kit, Solicitations, and Postings. In the Kit table I
have
stock number, part number, and description. In Solicitations I have Date
Issued, Due Date, Solicitaion Number, and Price. And in Postings I have
Postings and Date. Each day I enter the total number of Postings
available
for that day and any Kits we can quote on. Sometimes on any given day I
can
have 20 kits that we can quote on. The problem I am having is when I run
my
report I am not getting the correct sum of Postings. I noticed on my
report
it shows the number of Postings for each Kit entry for that day. I have
set
the hide duplicate to yes which hides all the Postings except one for that
day but when I sum the Postings field it totals all the duplicate too. Is
there anyway to sum only ones that are not duplicates? Any help is
appreciated.

Mark



.

Relevant Pages

  • Re: Not Suming Duplicates
    ... it shows my report but no total in the report footer. ... Running Sum Over All ... Kit, Solicitations, and Postings. ...
    (microsoft.public.access.reports)
  • Re: SPAMmers getting smarter
    ... Some malignant agent has sent out a SPAM e-mail to ... group postings directed to their email inboxes. ... deluge of SPAM posts today and yesterday has pushed many of the active/ ... spam - label it as spam and report abuse. ...
    (rec.music.indian.misc)
  • Re: Not Suming Duplicates
    ... Switch the query to SQL View. ... Then open the report in design view. ... I could work on and on November 2 there were 20 postings and 1 kit I ...
    (microsoft.public.access.reports)
  • Re: Not Suming Duplicates
    ... Parameters on the Query menu, and enter 2 rows in the dialog: ... When I view my report a box pops up saying ... Kit, Solicitations, and Postings. ... for that day and any Kits we can quote on. ...
    (microsoft.public.access.reports)
  • Re: Not Suming Duplicates
    ... When I view my report a box pops up saying ... Kit, Solicitations, and Postings. ... for that day and any Kits we can quote on. ... day but when I sum the Postings field it totals all the duplicate ...
    (microsoft.public.access.reports)