Order Of Child Table

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a report that prints a list of invoices and their associated
items....

There are just two tables on the report - invoice_header and invoice_item.

The one-2-many link is made between the tables using the invoice_number
field.

Initial Selected Area = invoice_header

I run the report as follows:

REPORT FORM myreport.frx FOR invoice_number = nInvoice PREVIEW

---------

That all works fine...nothing too complicated....what I'd like to do however
is show the report in a different sequence. The invoice_item table contains
a field called item_type which stores a number which defines the type of
item line (product, memo carriage etc). I'd like to display this report in
this sequence and thus be able to group the report by the value but
obviously I need to keep the relationship in tact. As soon as I change the
order of the child table the relationship is broken.....I can't really use a
view / query as this report is generated from a 'report generator' type
module which only works on base tables from the database.

Any help would be very much appreciated.


.

Relevant Pages

  • Create Report from VBA Code
    ... query that has different numbers of columns depending on ... one field in the query, called "Sequence". ... I'm trying to create a report from VBA code using DAO to ...
    (microsoft.public.access.reports)
  • Re: Combining Data from multiple fields
    ... You have a number of different "pieces" of information here, as represented by your "breakdown". ... Using an Autonumber for the "1115" is ok, so long as you don't care if there may be occasional gaps in the sequence of the numbers. ... Whenever you need to see the LSR on a form or report, use an expression to display it, either in a calculated field in the query that the form or report is based on, or in the Control Source of an unbound textbox on the form or report itself. ...
    (microsoft.public.access.forms)
  • Re: Combining Data from multiple fields
    ... Steve, your example got the ball rolling and I was able to successfully ... I can certainly understand you want the LSR to be *displayed* in the ... there may be occasional gaps in the sequence of the numbers. ... the form or report is based on, or in the Control Source of an unbound ...
    (microsoft.public.access.forms)
  • Re: pull one of each group per page?
    ... Then create a report with qselTypeSequence as the recordsource. ... Group first by Sequence with a group header and footer. ... You can force new page after the Sequence Footer Section. ...
    (microsoft.public.access.reports)
  • Re: Re-Number a table
    ... parentheses i.e. which is what I'm calling the "sequence number". ... corresponding Law firm record as you can see from the Law Firm report. ... Smith, Smith and Smith to display on the Law firm report following Smith, ... >> of the Lawfirm from the Lawfirm report. ...
    (microsoft.public.access.macros)