Results 1 to 2 of 2
  1. #1
    mod2000 is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    1

    Different aggregation levels


    Hi,
    I have the following problem:
    There is one table that contains projects, that has fields: id, departament and cost.
    Second table contains subprojects. Subproject has it's cost and foreign key to project.

    I need an idea, how to make grouping query that will give: departament, cost of projects in this departament, cost of subprojects in this departament.

    Please help me.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You really need a data model to identify the things of interest to your project.
    I see things like
    Department, Project, SubProject, Cost
    You have to identify how these pieces fit together.
    See the first few topics here
    http://www.rogersaccesslibrary.com/forum/topic238.html

    especially Normalization and Entity Relationship Diagramming

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Validation at form level
    By Kris in forum Forms
    Replies: 1
    Last Post: 06-28-2011, 06:48 AM
  2. Inventory Level Query With No Entries
    By robsworld78 in forum Queries
    Replies: 12
    Last Post: 06-18-2011, 02:10 AM
  3. generate multi-level csv
    By shank in forum Queries
    Replies: 5
    Last Post: 09-16-2010, 04:25 AM
  4. Multi Level Form
    By bkelly in forum Access
    Replies: 2
    Last Post: 08-28-2009, 11:15 AM
  5. Field Level Access
    By botts121 in forum Programming
    Replies: 0
    Last Post: 07-09-2009, 11:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums