Displaying total on a subform with a twist

[gwill23]

My database pulls data from Quickbooks using a make query to create a local table. I then pull item cost data from that table as you can see on the picture I have uploaded. I don't want to store this data because it will change from time to time. Therefore, there are several calculated fields based on a field that is looked up out of another table.

Right now the total is working (thanks to all the posts here), however, it is giving me some number I have no idea where it is coming from.

Any ideas?

 

[gwill23]

Can no one help me with this?

 

[apr pillai]

Change the Sub-Total Formula to =Dsum("[PurchaseCost]","Tbl_Loc_QB Inventory Items Only","[ListD]= " & [item#]). If item# is a text filed then the last segment must be "ListId= '" & [Item#] & "'")

Try it out.

a.p.r. pillai
http://msaccesstips.com

 

[gwill23]

Thanks that worked

Thanks lots. This worked great. My final code looked as follows to account for the Quantities of each item.

=Sum([qty]*(DSum("[PurchaseCost]","Tbl_Loc_QB Inventory Items Only","ListId= '" & [Item#] & "'")))