How can I get the sub-total and total of the purchase price to appear in an Asset report?
The sub-total and total of the current value appears automatically but I need totals of the purchase price.
Can anyone help?
Regards Ron
How can I get the sub-total and total of the purchase price to appear in an Asset report?
The sub-total and total of the current value appears automatically but I need totals of the purchase price.
Can anyone help?
Regards Ron
no idea without details about the data structure.
Thanks Adam.
I'm not sure of what you mean by "data structure"
The following is what I did:
I opened Microsoft Access. Clicked on the "Asset" template and named it "Household Inventory", set the file path then downloaded it. The form opened as "Asset List" and then filled in the details of my items in the relevant fields including the purchase price in the "Purchase Price" field. I finished entering all my items, saved the file, then right clicked on "Assets by Category" in the left pane under "Reports" then clicked "Open". I viewed the report and saw that the field "Purchase Price" was not sub-totalled or totalled and that the "Current Value" field was.
I need to know the total purchase price for each category. I don't know what elseI can say or what other information you want.
Regards Ron
I apologize Ron. What I meant was that you didn't specify where the data was coming from. Without saying, noone knows if you're using a MS template or not. You could've been using a custom built program. Sorry about that!
Anyway, if you look at the Current Value tBox in design view of the report, you'll see this in the control source:Just simply make a new box for yourself and copy it on over:Code:=Nz(Sum([Current Value]),0)Just takes a little inspection!Code:=Nz(Sum([Purchase Price]),0)
Remember too, that control names don't always = control source names. Always use the control name when you use a function in a control source, other wise you see that wonderful little #!NUM value. Something like that anyway...
Thanks Adam,
I wasn't sure how to add a new box so I just changed "Current Value" in the code to "Purchase Price" and moved the box over. It worked fine!
For future reference I would appreciate it if you could advise me of the steps tp take to make a new box.
Regards Ron