RE: 2 columns Report with multiple records

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

My Client is using Every 3x4 Labels for this report. I have no choice for
labels paper format (Lettel with multiple columns - labels), so I have no
choice even for subreport label format. My problem is not "to many records
for labels space". I testet just for 2 records and result is: Access put next
record into the next column(label). Is that the gray area in Microsoft ACCESS
Database? I can solve the problem converting source table into another table
where for each Athlete will be only one record with all sport event fields.
It will take more time and complicate the application. I need from the
Microsoft definite answer: Does Column in the Report support multiple records
or it support only single record?
Thanks in advance
--
Ilya


"Duane Hookom" wrote:

If your detail section is 3" x 4" then each record in your report's record
source will take up that much space. I would hate to think a single detail
section would be filled with multiple records (other than by some code I
might add).

If you want multiple records than create a 4" wide subreport and add it to a
multiple column main report that is based on only the unique athlete names.
Set the link master/child properties to the athlete primary key or whatever.

--
Duane Hookom
Microsoft Access MVP


"Ilya" wrote:

Thanks for advise, is there a sample of this solution?
Nevertheless, why 3X4 column can not handle mult. recs, like normal detail
section.
The Attribute GrpKeepTogether has choices Per Page and Per Column, meaning
You can keep the group on the column. Is'nt it wright? Where is it in
documentation that column is for single record?
Thanks for help
--
Ilya


"Duane Hookom" wrote:

If you want multiple records (several for one athlete) printed on a single
label, then I would create a main report of labels based on unique athlete
records. Then use a subreport in the detail section for the sport event and
times.
--
Duane Hookom
Microsoft Access MVP


"Ilya" wrote:

Each Report Column is Every Label 8364: 3" by 4". I need to display in each
such column :

Athlete Name
SportEvent(1) Time(1)
SportEvent(2) Time(2)
SportEvent(3) Time(3)

Each pair: (SportEvent, Time) belongs to defferent record in the table
--
Ilya


"Duane Hookom" wrote:

One record will display in one detail section. I can't imagine what you
expect to display. Perhaps you can type in a little sample of records and
expectations so we can understand.

--
Duane Hookom
Microsoft Access MVP


"Ilya" wrote:

In my Report page setup
Columns = 2
with = 4.15"
height = 3.33'
It works OK for displaying single record fields.
Now I need to show in each column several records. Report shows only one
record per column. How to show multiple records in the column like in the
Normal Report?
Thanks in advance.
--
Ilya
.

Relevant Pages

  • Re: Need to create a 14 ages form.
    ... Did you create multiple sorting and grouping header and footer sections ... MS Access MVP ... "Duane Hookom" wrote: ... wishing to report multiple records so that 14 pages of records get ...
    (microsoft.public.access.formscoding)
  • Re: Label report printing error
    ... Any code that relies on the form events across multiple pages is unreliable. ... You can use the code in that article to skip the initial labels, ... What happens is that the report events are not triggered for all the ...
    (microsoft.public.access.reports)
  • RE: None of my report labels print !?!
    ... I was hoping I would not have to recreate the report, ... "Duane Hookom" wrote: ... Microsoft Access MVP ... None of the labels appear in the report. ...
    (microsoft.public.access.reports)
  • Re: Reporting Data accross the page.
    ... "Duane Hookom" wrote: ... How to Show Only Labels in the First Column of a Report ... Nest No. Species # Eggs Egg Color (these are in the page ...
    (microsoft.public.access.reports)
  • RE: None of my report labels print !?!
    ... I expect no new labels or line show when added. ... Microsoft Access MVP ... "Duane Hookom" wrote: ... If you can't figure this out, you may need to create a new report. ...
    (microsoft.public.access.reports)