Access Help Please

[lookup13]

I have a Table with the following columns :

Item Qty Price StockTotal
wig 2 $1.00 $2.00
ABC 3 $3.00 $9.00

How do config the stock total to work ?

Also how can I get a total Inventory
in this Example $11.00

Any Ideals

Thank you for your help

 

[MichaelintheUK]

Hello Lookup13

Use a query with the 4th column as a dummy or derived field e.g. MyTotal - place a colon next to it and then a calculation e.g. MyTotal:[Qty]*[Price]

If this causes problems try using nz (null to zero) to convert empty values to zero and Ccur to convert to currency e.g.

MyTotal:Ccur(Nz([Qty]*[Price]))


Fields Item Qty Price MyTotal:[Qty]*[Price]

For an overall total - add the saved query above to a new query.

Make it an aggregate query - use the sigma symbol from the menu in query design using the above query

Field myTotal
Table qryName
Total Sum

Thanks


Add the MyTotal field

 

[lookup13]

Sorry about delay will give it a shot, thank you for your advise

 

[lookup13]

I want to get a total for inventory , any other ideals?