Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hagerbmr

    Simple Module Coding: altering equations in Control Source

    Ok Tony, I got that database up and running thanks to your help. Now I have moved on to one with a very similar problem. I solved my last data problem with the expression in query = to Expr1: IIf([V_Chk],0,(Sum([t_table]![V_Ucarrieramount]-[t_table]![V_Acarrieramount]+[t_table]![V_AdminFee])))...
  2. hagerbmr

    Simple Module Coding: altering equations in Control Source

    Alright Tony, Your right about everything, and it is all working fine up to the very end now. I created a column for yes/no, and that works ok. My only problem is calculating the data. My exact expression in my query is: v_Amount...
  3. hagerbmr

    Simple Module Coding: altering equations in Control Source

    Another problem arose with the checkbox issue. I am using it in a form, with multiple entries. It is for account's with multiple invoice violations, and there will be multiple entries per account. I need to be able to void out certain individual entries per account. While the checkbox did work...
  4. hagerbmr

    Simple Module Coding: altering equations in Control Source

    Thanks Tony, That works great. Yet, there is that other step that is still needed. What I do is take the information from Box 1 and 2 (X and Y), and insert them from the table that stores their value and reference in a query. The query takes the info and does the same expression (x-y), and...
  5. hagerbmr

    Simple Module Coding: altering equations in Control Source

    I am designing a database for finances and have encountered only one problem. There are three fields in a form, all for currency. Enter two numbers which log into a table, then a query takes the difference and logs it for reference on another form. The third box has the simple equation x-y...

Part and Inventory Search

Back
Top