Re: Report previews multiple times

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

You first stated "but the discrepancy information is on fairly small
attached sub-report" and then stated the discrepancy records are alos in the
main report. My suggestion has been to remove the discrepancy table from the
record source of the main report.

--
Duane Hookom
MS Access MVP
--

"Dan" <Dan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF0C6291-7EE5-421E-A1E9-6E94792538B2@xxxxxxxxxxxxxxxx
> Yes, it has two quearies that have the discrepancy information, joined to
> the
> main table by report number
> --
> Dan
>
>
> "Duane Hookom" wrote:
>
>> Does your main report record source contain the discrepancy records?
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Dan" <Dan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:4FEDE552-1A0F-49FF-8D1A-D6BCE27904AB@xxxxxxxxxxxxxxxx
>> > The main report does have a lot of information, but the discrepancy
>> > information is on fairly small attached sub-report. The sub-reports
>> > are
>> > grouped by report number with the main report, and the report number
>> > field
>> > is
>> > the only one the reports have in common.
>> > Dan
>> >
>> >
>> > "Duane Hookom" wrote:
>> >
>> >> 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: Report previews multiple times
    ... I expect you have too much detail in your main report. ... main report should not contain the discrepancy information. ... > report number once for each entered discrepancy. ...
    (microsoft.public.access.reports)
  • 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)