Re: Report previews multiple times

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I expect you have too much detail in your main report. It seems that the
main report should not contain the discrepancy information.

--
Duane Hookom
MS Access MVP
--

"Dan" <Dan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A581711A-B963-4D0B-9596-686C3F7A39DB@xxxxxxxxxxxxxxxx
>I work with a database that allows users to enter multiple discrepancies
>into
> a table under one unique report number. The table and queary both show
> the
> report number once for each entered discrepancy. I have a report that
> shows
> the discrepancy information in a sub-report, but the entire report repeats
> itself for each entered discrepancy. How can I get each report to preview
> only once if it has multiple discrepancies? Thanks for any help
> --
> Dan


.

Relevant Pages

  • Re: Report previews multiple times
    ... I removed the discrepancy table and found the problem was with my main report ... It is based on quearies itself, ... > attached sub-report" and then stated the discrepancy records are alos in the ...
    (microsoft.public.access.reports)
  • Re: Strange W-2 and story
    ... no explanation for the discrepancy. ... was promptly told "You can ignor the W2. ... we report to the IRS." ...
    (misc.taxes)
  • Re: I am glad that the science is settled.~
    ... A report from the Brookhaven National Lab. ... Schwartz's analysis attributes the reasons for this discrepancy to a ...
    (sci.physics)
  • Re: Report previews multiple times
    ... Does your main report record source contain the discrepancy records? ... >> Duane Hookom ... >> MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: Report previews multiple times
    ... You first stated "but the discrepancy information is on fairly small ... attached sub-report" and then stated the discrepancy records are alos in the ... record source of the main report. ...
    (microsoft.public.access.reports)