Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report - I can't figure out (MS Access 2007)

    I have to design a report into which records have to be grouped on records which have a boolean field 'dg' set on true and records with the boolean "dg" set to false.
    Futhermore, in the section with the records with the boolean "dg" set to true, one extra field must be shown for each record e.g; the weight. of the product
    This section must also begin with a fixed text above all the records saying that these records are all of type DG, and on the bottom of this section , the tolal of all weights of all these records must be shown.
    If there are only records to be shown that has the boolean "bl" = false, then this section may not be displayed.
    Is there someone who can give me some help to realize that in ACCESS 2007

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report - I can't figure out (MS Access 2007)

    You could create two queries - one that selects records for which dg = true, and another one for which dg = false. Then create two separate reports, one based on each query. You can display the total weight in the report footer of the report based on the query for dg = true.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report - I can't figure out (MS Access 2007)

    Thanks for the tip, but this isn't what i need. The two kind of records must get on one and the same report.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report - I can't figure out (MS Access 2007)

    You could place the two reports as subreports on an otherwise blank report.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report - I can't figure out (MS Access 2007)

    Hans that's quiet a smart advice, wonderfull ! Thank you very much !!


    Greetings

    Jacques

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •