Results 1 to 2 of 2
  1. #1
    murphyB is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    2

    Question Complex Lookup?

    Hi all.

    I'm not terribly proficient with Access and I'm looking for a solution to the following problem. Any help you can provide would be wicked awesome.

    I have created a budget database (this isn't the complete db, just everything relevant to my question:

    Clean Budget


    -ID (PK)
    -Date
    -Amount
    -Project

    Projects
    -ProjectID (PK, related to "Project" in Clean Budget table)
    -ProjectName
    -BudgetAmt

    So, the Clean Budget data rows are imported from monthly Excel budget reports. What I want to do is create something (a report) that will display each project, the budgeted amount, and the totals from all records in Clean Budget associated with each project. A twist on this is that while I can make a query that does that, it won't show any projects where there's no spending.

    I've tried creating a field in the Projects table called "ActualAmt" but I don't know how to make that populate dynamically from matching rows in Clean Budget. I feel like this would be the easiest if possible because I can then just create a query and report directly from the Projects table.

    Again, if you can shine any light on this for me, I would really appreciate it.

    Thanks!
    -MurphyB

  2. #2
    murphyB is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    2
    Actually, no response needed. I found that I could manage this by creating an outer join in the two tables.

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

Similar Threads

  1. Complex Update query
    By niihla10 in forum Queries
    Replies: 1
    Last Post: 08-28-2009, 01:02 PM
  2. Replies: 2
    Last Post: 08-26-2009, 10:43 AM
  3. Replies: 1
    Last Post: 07-08-2009, 03:31 PM
  4. Complex Date Comm/Amt Formula
    By JLongo in forum Programming
    Replies: 0
    Last Post: 11-21-2008, 10:24 AM
  5. Lookup
    By neon'00 in forum Forms
    Replies: 2
    Last Post: 04-14-2007, 01:19 PM

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