Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    178

    Unanswered: Major reporting problem please help

    Hi Guys,

    Im having a really annoying problem with reports, can someone please help me.


    I have an Order table in which OrderID is my PK.
    The Order table is linked to a MaterialsOrder table through the OrderID as a FK.
    The Order table is also linked to the ManpowerOrder table, again through the OrderID as a FK.

    Im using the report wizard to create the report to show the order with materials and manpower that are linked to it.
    However it seems that when I do this, the same materials are listed again with each occurrence of manpower ordered.
    All I want is the list of man power and list of materials.


    How can this be achieved? I hope someone can help.


    Aboo

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Structurally, how does man power fit in to this?

    Sounds like you need to group on order and sum the materials and man power, but I seriously doubt you'll get there using the form/report wizards unless you get a query to give you the right data first.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    May 2006
    Posts
    178
    Hey Trekker,

    Thaks for your reply, I managed to resolve this by inserting subforms intot he report which listed the materials and manpower in a grid format.

    Aboo

    P.s I created a query manually and to be honest i had repetitive lines for most of the information, it looked horrible.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Glad you got it sorted.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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