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])))...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.