ACCESS FEED: Re: [MS_AccessPros] Re: Word Like Table in MS Access Report

Jumat, 24 Februari 2012

Re: [MS_AccessPros] Re: Word Like Table in MS Access Report

I am understand what do you mean by Invoice, if you are asking about
sections then I have the following

Page Header / Footer
InvoiceID Header/Footer
Detail

SubReport has the following Record Source

SELECT tblInvoice.InvoiceID,[tblInvoice Details].InventoryCode, [tblInvoice
Details].Quantity, [tblInvoice Details].Rate, tblInventory.InventoryName,
[tblInvoice Details].SalesTax, [tblInvoice Details].SED,
CCur([Quantity]*[Rate]) AS ExtendedPrice, "Ring Traveller" & " " &
[InventoryName] AS InvName

FROM tblInvoice INNER JOIN (tblInventory INNER JOIN [tblInvoice Details] ON
tblInventory.InventoryCode = [tblInvoice Details].InventoryCode) ON
tblInvoice.InvoiceID = [tblInvoice Details].InvoiceID;

and main report has the following Record Source

SELECT tblCustomer.CustomerName, tblCustomer.ShippingAddress,
tblCustomer.ShippingCity, tblInvoice.CustomerCode, tblInvoice.InvoiceID,
tblInvoice.InvoiceNumber, tblInvoice.InvoiceDate, tblInvoice.Freight

FROM tblCustomer INNER JOIN tblInvoice ON tblCustomer.CustomerCode =
tblInvoice.CustomerCode;

On Fri, Feb 24, 2012 at 12:57 PM, Duane Hookom <duanehookom@hotmail.com>wrote:

> **
>
>
>
> Does your main report contain more detail than just the invoice level?
>
> I had asked about your Record Sources but you didn't provide these.
>
>
> Duane Hookom
> MS Access MVP
>
>
>
> > To: MS_Access_Professionals@yahoogroups.com
> > From: maxccess@gmail.com
> > Date: Fri, 24 Feb 2012 12:49:04 +0500
>
> > Subject: Re: [MS_AccessPros] Re: Word Like Table in MS Access Report
> >
> > Dear Duane
> >
> > Yes I has created Subreport
> >
> > No, I am not remove detail section from report, actually I put subreport
> > there.
> >
> > Link Master/Child is InvoiceID
> >
> > On Fri, Feb 24, 2012 at 12:21 PM, Duane Hookom <duanehookom@hotmail.com
> >wrote:
> >
> > > **
>
> > >
> > >
> > >
> > > Abdul,
> > > I'm not convinced you have this set up correctly.
> > >
> > > Did you create a subreport?
> > >
> > > Did you remove a level of detail out of the main report?
> > >
> > > Can you tell us about your record sources and Link Master/Child
> properties?
> > >
> > >
> > > Duane Hookom
> > > MS Access MVP
> > >
> > >
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > From: maxccess@gmail.com
> > > > Date: Fri, 24 Feb 2012 09:37:41 +0500
> > > > Subject: Re: [MS_AccessPros] Re: Word Like Table in MS Access Report
> > >
> > > >
> > > > Clive-
> > > >
> > > > I have already Grouping on InvoiceID with "Keep whole group together
> on
> > > one
> > > > page"
> > > >
> > > > On Thu, Feb 23, 2012 at 5:57 PM, Clive <zctek@aol.com> wrote:
> > > >
> > > > > **
> > >
> > > > >
> > > > >
> > > > > Hi Abdul,
> > > > >
> > > > > You will need to change the Sorting_And_Grouping for
> > > > > the Invoice.
> > > > >
> > > > > Open the report in Design_View and click on
> > > > > View/Sorting_And_Grouping from the menu.
> > > > > You will probably just need to group on an
> > > > > Invoice Field.
> > > > >
> > > > > Regards, Clive.
> > > > >
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com, Abdul Shakeel
> > > <maxccess@...>
> > > > > wrote:
> > > > > >
> > > > > > Dear Duane,
> > > > > >
> > > > > > thanks it works, but when an invoice have more than one record
> the it
> > > > > > splits into to pages, and become even worse if invoice have more
> > > than 2
> > > > > or
> > > > > > more records, however I have set can grow/shrink property to no
> > > > > >
> > > > > > On Thu, Feb 23, 2012 at 10:44 AM, Duane <duanehookom@...> wrote:
> > > > > >
> > > > > > > **
> > > > >
> > > > > > >
> > > > > > >
> > > > > > > I think you can do this with a subreport of fixed height. Make
> > > sure the
> > > > > > > subreport can't grow or shrink.
> > > > > > >
> > > > > > > Duane Hookom
> > > > > > > MS Access MVP
> > > > > > >
> > > > > > >
> > > > > > > --- In MS_Access_Professionals@yahoogroups.com, Abdul Shakeel
> > > > > <maxccess@>
> > > > > > > wrote:
> > > > > > > >
> > > > > > > > Dear All,
> > > > > > > >
> > > > > > > > I want insert a table in access report just like we do in
> word
> > > but
> > > > > with
> > > > > > > > some fixed height in width let say the table height 3 in"
> fixed
> > > even
> > > > > if
> > > > > > > it
> > > > > > > > had only one record, I post these question previously in
> > > different
> > > > > manner
> > > > > > > > got some answer though which are not helpful, I also have
> tried
> > > line
> > > > > > > method
> > > > > > > > but no luck. I am trying to make an invoice. any suggestions.
> > > > > > > >
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>