Creating Final total

[Gingest]

I have been trying to create a final total within my database for the last 3 weeks I have tried a few things which still don't work.

Transaction Form
Query Transaction Item Sub-form

within the sub-form I have a quantity which is * by the Price to give a total for each individual item which works but I cant get the final total that is in the Transaction form to work Soo confused

 

[NickHa]

Your details are somewhat sketchy, but something like this should do what you need:

SELECT Sum(Quantity*Price) AS Total FROM table;

Sustitute your filed names for 'Quantity' and 'Price' and your table name for 'table'.
You can put this in your parent form as the data source for a textbox control or similar.

 

[RainLover]

In your Query create a Field, SubTotal:[Quantity]*[Price]

Then on the Form create a Text Box with its Control Source as Sum([SubTotal])

Let me know how this goes.

 

[Gingest]

Sorry for not getting back sooner it work perfectly i shall keep that in mind in the future

Thank you

 

[RainLover]

Sorry for not getting back sooner it work perfectly i shall keep that in mind in the future

Thank you

Most Welcome.