Re: Report previews multiple times

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

I removed the discrepancy table and found the problem was with my main report
queary the whole time. It is based on quearies itself, and causing the
repeat reports. I'm trying to rebuild the main report queary from tables to
prevent that.
--
Dan


"Duane Hookom" wrote:

> 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: 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)
  • 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)