Re: Report previews multiple times

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

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: Crosstab Report
    ... MS Access MVP ... I try to write the report my headings/totals crash. ... "Duane Hookom" wrote: ... some of the information you posted to the query and found it very ...
    (microsoft.public.access.reports)
  • Re: Passing a value from a form to a Reports SQL stored procedure
    ... Duane Hookom wrote: ... MS Access MVP ... second page of my report ... Dim strVersionID As String ...
    (microsoft.public.access.reports)
  • Re: Timetable
    ... FieldName3 Datatype (display this one on time line) ... MS Access MVP ... I've been looking at your ship rotation report, and I've taken it apart to ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: Timetable
    ... out on each of my e-forms. ... I have tried and managed to change the timeline on the report to weekly so I ... "Duane Hookom" wrote: ... MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: Subreport vs queryquestion
    ... detail section is shortened to only accomodate the size of the controls. ... Duane Hookom ... MS Access MVP ... What section of the report are the controls in? ...
    (microsoft.public.access.reports)