Search results

but still "Item_Value_Previous" get sum of both items i used this Expression before Previous: DSum("[item_value_current]","inv_contract_details","[contractcode] = " & [ContractCode] & " AND [item_code] = " & [item_code]) and it was working but don't know what happend

awesome thank you !

If you open "Qry_Contract_Details_Subform" form in design view you will see total field in the footer .. this total is the invoice value I want this total to go to invoice value in invoice form after update or after change it should be 1500 .. sum of all "item_Value_Current" items

this form is subform in invoice form >> when you choose invoice to and project name it should show the details of the project from Qry_Contract_Details query and i have made form for it in order to make total field to "item_Value_Current" the "item_Value_Current" is the invoice value...

Qry_Contract_Details subform

so i can make new field for item code "auto number"

great as usual Mr. Mike it's worked if you let me **previous field in "Qry_Contract_Details" should dSum all "item_Value_Current" in inv_Contract_details table by to criteria contractcode and item_code i have try it before it was working now it's not , don't know why ** can we make the default...

now i have made query for "Contract_details" Table and Append Query to Add Values to "inv_Contract_details" Table referring to Invoicenumber And ContractCode when i click Tarhel Button in "invoice" Form but i face this MSG in Attach what is the problem here !! " you can choose invoice to...

thank you i will give it a try i hope i can do it myself Lol

yes exactly the details changed from invoice to another by the progress the total value of item is fixed but the progress changed

any ideas ?

Ok let me try to explain it is construction company We make contract to make something by total value let’s say 1000,000 this value is break down to items let’s say electrical works 500,000 Mechanical works 500,000 if you see add new contract form you can see what i talk about Now let’s move...

I think you didn’t get my point sorry ,, I were about to reply you but i slept Lol I want somehow to link contract details to invoice form So if i choose project name ,it’s items details appeared in the sub form so i can write the current progress on it and the total of it moved to invoice...

thank you for helping i have edit the post to one black color in order to be clear i have download the sample database but unfortunately i didn't find what i need

hi Friends , i have contract form which contain Contract_details subform every contract have his own details items in invoice form i have feild called invoice value it should be sum of "item_Value_Current" in contract_details table now i want When I choose project name , the items of this...

i assumed that when i put the calculation of sum in the footer of the project it will take the project as criteria !

Sorry mike if my reply bother you ,, i am brand new access user so i have searched a lot to figure out how you creat project name footer but I didn’t find anything You have removed a lot of criteria that i need So i need to know how you add project name footer in order to make only small...

Up

thanks for your effort but you have made a lot of changes which i don't need to but how you create project name footer ? so if putting sum cell on it is the solution i will give it a try

That is exactly what i want please send me file after update:)