Hey Duane,
Is this done by way of Report / Subreport?
Toukey
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Toukey,
>
> Apparently you need to group by MAWB first, then HAWB (with a footer). Set the "Force New Page" to "After Section" in the HAWB footer section properties.
>
> Duane Hookom MVP
> MS Access
>
> ----------------------------------------
> > From: no_reply@yahoogroups.com
> >
> > I am trying to create a report from a query with the following fields:
> >
> > mawb
> > clientno
> > hawb
> > desc
> > ctn
> > pkg
> > kgs
> >
> > Having a problem with the layout of the report which should look like the following. For each MAWB there can be one or more HAWBs. Each HAWB has one Clientno, however each Clientno can have one or more Desc. Need to have each HAWB on a separate page.
> >
> > Page 1
> >
> > MAWB: 123-4567-8900
> > HAWB: 9876
> >
> > Clientno: A123
> >
> > Desc ctn pkg kgs
> > Printers 1 2 10
> >
> > -------------------------------
> > Page 2
> >
> > MAWB: 123-4567-8900
> > HAWB: 9888
> >
> > Clientno: A123
> >
> > Desc ctn pkg kgs
> > Printers 1 2 10
> > Ink 2 1 15
> > ----------------------------------------
> >
> > Thanks
> > Toukey
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar