Results 1 to 2 of 2
  1. #1
    pshawk is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2010

    trouble creating correct criteria

    perhaps i have set up the table incorrectly but as it stands now there are these fields

    Fund 1 (value list: soc, iwg, general funds)
    amount 1
    Fund 2 (value list: soc, iwg, general funds)
    amount 2
    fund 3 (value list: soc, iwg, general funds)
    amount 3

    the Fund fields are value lists where the user can select which of three funds the amount will be withdrawn from

    the end result a report that sums the amounts where the fund is x.
    in english the criteria is

    sum (amount 1 where fund 1 = soc )
    sum ( amount 2 where fund 2= soc)
    sum (amount 3 where fund 3 = soc)
    and then create a grand total.

    I have tried every thing i can think of but i am not getting anywhere close to the result i need. i need to start from scratch and get this to work

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Houston, Texas USA
    Take a look at the attached query snapshot, both in the design and query views. There are good tricks in the columns that have an alias name.

    Note that the last two column names were built by the Access Build Query Wizard.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-23-2010, 04:01 PM
  2. Opening form to correct record. Bookmark?
    By stephenaa5 in forum Forms
    Replies: 11
    Last Post: 12-29-2009, 02:43 PM
  3. Trouble viewing correct data
    By KevinH in forum Access
    Replies: 11
    Last Post: 07-06-2009, 07:16 PM
  4. Creating a list viewed by 2 criteria
    By phillyon in forum Queries
    Replies: 0
    Last Post: 12-01-2008, 11:46 AM
  5. not correct running total in group
    By cmk in forum Reports
    Replies: 1
    Last Post: 12-06-2006, 05:56 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