Need inventory tracking and invoice forms

[jayvan39]

I got it to work, but now i am having trouble with the total amount sum
I have the quantityOrdered * costperunit = amount net



and would like the amountnet totals to be the sum for "ordertotal" below the footer

[jayvan39]

I got it to work

but i am having trouble with the following
I have the quanitityOrder * costperunit = amount net which works great
but i would like the sum of all the amount nets to = the "Orderedtotal" box below the footer

[burrina]

Is Orderedtotal an unbound field? Have you tried =Nz([quantityOrder]*[costperunit],0)

If so, what is the result, error? Are the fields all set to currency as format? Need more details when you post Please!
Try using the add builder, the three dots and let it build it for you under properties. see screenshot.

[jayvan39]

ordertotal is an unbound textbox

[burrina]

[QuantityOrdered]*[UnitCostPerItem] Should be the AmountNet
Then do a Sum([QuantityOrdered])

[jayvan39]

I dontthink you are follwing me. If a user neters more than one item there will be multiple AmountNet's, I want the total of all the AmountNet's to be in the OrderTotal box

[jayvan39]

this should explain what i am looking for

[burrina]

And I gave you the code to Sum the AmountNet
You simply Sum your total amount in your form footer or wherever you want.

[jayvan39]

why wouldn't it be =Sum([AmountNet]) ? which doesnt work.. I have tried your code also.

Also when i enter a new item line it automatically resets my transactionID/InvoiceID to null.. I would like the form to open up as a new form and the user can either start from new or enter a past transaction ID to pull up the the old record.. but the items need s to be able to have multiple items for one transactionID/invoiceID

[burrina]

Care to upload a copy of your database without any confidential information of course for testing?

[jayvan39]

it keeps failing, i even zipped it?

[burrina]

Gee, how big is it, there is a size limit! Maybe compact the db, then try using another zip utility!

[jayvan39]

it was 4mb

[jayvan39]

i just compressed it and am uploading it now

[jayvan39]

okay here ya go