Subtotals
Feb 15, 2008
Not sure if the question belongs in queries or reports. I've a list of product codes that we produce daily, weekly, monthly. Some repeat several times within a week or month. I want to list them in order by cost. I can do that, but when they repeat, I wanted to combine them into one subtotal, then get sorted by cost with the other product codes.
Right now, I'm dumping the table into Excel and doing it manually. I sometimes have 7 lines of the same product code. I insert a line and subtotal them by their product code. Then, I delete the data leaving the subtotal line. I then can sort them with the other subtotal and other once product codes.
:-[ I'm hoping this is an easy answer. I'm not good with Access. It's turned out to more of a trial and error thing for me.
Thanks
Laura
View Replies
Aug 2, 2006
Hi,
I'm trying to produce a subtotal in a query to compare it to another field to determine whether to include the record or not.
For example, in my table I'd have,
ProductA 3(units) Lot1
ProductA 4(units) Lot2
ProductB 2(units) Lot3
ProductA would also have a minimum inventory level of 6 in another table. So the parameter I would like to create would sum all the different lots of ProductA and compare it to the MinLevel entry.
Any ideas?
View 3 Replies
View Related
Nov 15, 2005
I have a report that has the following categories:
Parent--Unit--Month--Spend--Expected--Rate of Expected
Now i have it summing the spend by Parent. I would like it to sum by Parent by month, is this at all possible?
View 1 Replies
View Related
Apr 5, 2006
Hi there - I've looked at quite a few posts and although some of them seem to start of heading in the right direction there doesn't appear to be anything that quite hits the spot for what I'm looking for.
I'm trying to create a query that creates the following (see spreadsheet as typing it out didn't help.)
I hope that's clear - any help appreciated.
Cheers,
Mark
View 1 Replies
View Related
Dec 1, 2005
I am creating a Sales History Report. It displays products sold by customer by Sales Rep. The groupings are Sales Rep, Customer, and Product. I am hiding the detail section which contains invoice line item records. So the report shows the product subtotal by Company. The problem I have is I need to see the product subtotals in the Sales Rep and Report Total sections also. So the report would look something like this:
Sales Rep A
Customer A
Product A
Product B
Product C
Customer B
Product A
Product B
Product C
Sales Rep A Total
Product A
Product B
Product C
Sales Rep B
Customer R
Product A
Product B
Product C
Customer S
Product A
Product B
Product C
Sales Rep B Total
Product A
Product B
Product C
Report Total
Product A
Product B
Product C
Is there a way to accomplish this without doing sub-reports?
View 3 Replies
View Related
Apr 17, 2007
I am looking to do some calculations in a form that can be output to a report.
Basically within the form i have 4 controls as well as the others
Tables
Benches
Chairs
Other Equipment
These controls are bound to a table.
The first 3 controls need to have have fixed costs 2.00, 1.50 and 1.00 respectively. The last needs to be manual input as it can be different dependant on the items in the memo box.
I then need each one to calculate separately to give me a sub total then add all together to give a total
This total needs output to a report for sending out a bill.
I currently have the 4 controls with 4 unbound textboxes beside them for the subtotals:
TablesTotal
BenchesTotal
ChairsTotal
OtherTotal
4 unbound textboxes for the fixed amount and manual input amount (maybe this is where i'm going wrong)
TableCost
BenchCost
ChairCost
OtherCost
and then one more unbound textbox for the total:
TotalTotal
Do i need to create a table for the fixed costs? If so whats the best way to set this up. What should i be binding textboxes too if anything?
Hope this makes sense.
Thanks in advance
View 2 Replies
View Related
Mar 9, 2005
Hi,
i'm working in access 97 and am having difficulties pulling a subtotal or referencing any fields on my subform on my main form. I've searched the forum and help and tried to apply the info provided, but i still can't seem to get it to work.
as far as i can tell this should work:
=[MySubForm].[Form]![TxtTotalStaffNumbers]
but i'm still getting the dreaded #Name? error.
anyone got any clues as to what i'm doing wrong?
what about the case where the subtotal i'm referencing is a calculation such as =Sum([Quantity]*[FacilityArea]). Should i still be able to reference it on my main form by pointing to the name of the field?
Thanks very much!
View 3 Replies
View Related
Nov 4, 2011
I have a list of coded transactions in column A, Amounts in B and Dates in C.
I want to show subtotal for all amounts with the same codes in D
I can do this simply without the date parameters, but I need to give timeframes.
When I add the [From] and [Until] questions it then shows the amounts next to each date even though the date column is hidden.
I'm aiming for the subtotal of amounts for same codes between given dates:
Example
ABB 100 1/6/11
ABB 100 6/6/11
ABB 150 1/8/11
ABC 50 1/7/11
ABR 50 2/8/11
ABJ 50 1/5/11
If I enter 1/6/11 and 30/6/11 I would expect ABB to show 200 total as 150 is after that date and so not counted.
View 2 Replies
View Related
Nov 19, 2013
I have a form built with multiple buttons. Once the user clicks the button and enters their parameter, I am using VBA to export the data to an excel pivot table. I would like to turn the subtotals to false so as the user clicks the check boxes in the pivot there are not any totals, subtotals, or grand totals. I am not sure how to add that to an existing query?
View 1 Replies
View Related
Nov 19, 2013
I have a form built with multiple buttons. Once the user clicks the button and enters their parameter, I am using VBA to export the data to an excel pivot table. I would like to turn the subtotals to false so as the user clicks the check boxes in the pivot there are not any totals, subtotals, or grand totals. I am not sure how to add that to an existing query?
View 1 Replies
View Related
