Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2011
    Posts
    2

    Nice And Easy Ones For You Gurus

    Hi



    Been a while since I have done this in Access.

    I want a simple query.

    I have 3 Fields. I want to add the coloumns which are currency values from 2 and compare them against a final columns

    e.g

    SELECT Description From INVOICE WHERE (DepositAmount+BalanceAmount) < TotalAmountDue

    Any Thoughts...I am being useless...

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    If you want to see the total of DepositAmount+BalanceAmount, you have to put it in the SELECT clause of the query

    SELECT Description, DepositAmount+BalanceAmount

    By putting it in the WHERE clause as you have it now, the query will only return those records where the sum of the two fields is less than the TotalAmountDue.

    Out of curiosity, from where is the TotalAmountDue coming.

  3. #3
    Join Date
    Feb 2011
    Posts
    2
    Cheers.

    Got it now, think it was having probs with Null columns.

    Have another problem now, might be back in a bit...

    Cheers...

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

Similar Threads

  1. Easy question
    By Danzig in forum Access
    Replies: 11
    Last Post: 10-28-2010, 06:48 PM
  2. I know this has to be easy...
    By MelindaP in forum Access
    Replies: 7
    Last Post: 08-20-2010, 02:15 PM
  3. Open Querry that looks nice???
    By 95DSM in forum Access
    Replies: 2
    Last Post: 07-11-2010, 11:11 PM
  4. Probably missing something easy
    By z1efuller1 in forum Database Design
    Replies: 5
    Last Post: 11-12-2009, 11:18 AM
  5. easy checkbox question
    By nelsok in forum Forms
    Replies: 1
    Last Post: 06-09-2006, 05:46 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
  •  
Tech Forums: Microsoft Office Forums