Results 1 to 4 of 4
  1. #1
    hschrunk is offline Novice
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    2

    Question Formula

    Ok I have created several Access databases in Access 2003. but it has been over 8 years ago. I am trying to create a now in Access 2007 and something I thought would be simple is giving me a headache.



    I want the database to have a field (currency) but I always want that field to deduct $69 from the amount entered.
    The amount entered will always be different, but I always want $69 deducted.


    HELP!!

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Unless there's a really good reason for wanting the deduction stored in the table, I'm usually against storing calculated values in tables. Without knowing the reason for this, my first reaction is to recommend that the data entered be the data stored and then using queries to deduct $69 from it.

  3. #3
    hschrunk is offline Novice
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    2
    This database is to keep up with clients and what they owe us. We are the "middle person" so our vendor gives us a price that includes $69 - but out customer only owes us the price - $69.

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    So the only times you would actually need the customer payment price is during reports. I'd still stick with storing what is entered and then calculating after the fact.

    If you insist,

    UPDATE mytable
    SET CustPrice = VendPrice - 69
    WHERE whatever criteria you have to select that record.
    Last edited by TheShabz; 05-18-2010 at 01:41 PM. Reason: grammar fail

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

Similar Threads

  1. Refine my formula, please
    By DianeG in forum Queries
    Replies: 4
    Last Post: 05-19-2010, 09:20 AM
  2. Help with formula for Query
    By goldie6175 in forum Queries
    Replies: 1
    Last Post: 02-18-2010, 11:29 AM
  3. Concatenate Formula
    By Shingo in forum Programming
    Replies: 1
    Last Post: 07-25-2009, 09:14 AM
  4. formula on report??
    By dike969 in forum Access
    Replies: 0
    Last Post: 03-05-2007, 01:58 AM
  5. Max formula in Access
    By mohsin74 in forum Programming
    Replies: 2
    Last Post: 12-26-2006, 07:21 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