By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,076 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Query (or VBA) to combine records by category

P: 25
Hello everyone!

All ideas would be very appreciated.
I have a table with let's say information about sales by category:

product model price
car honda $10000
car nissan $11000
truck chevy $15000
truck ford $16000
SUV GMC $20000

as an output I need to add the following in the same table:

product model price
car total $21000
truck total $31000
SUV total $20000

so as a result i have a table that looks like this:

product model price
car honda $10000
car nissan $11000
car total $21000
truck chevy $15000
truck ford $16000
truck total $31000
SUV GMC $20000
SUV total $20000

In actual table there are more "categories" that the data should be devided by and much more fields to combine.

Any suggestions?
Thanks.
Jul 18 '07 #1
Share this Question
Share on Google+
2 Replies


Stang02GT
Expert 100+
P: 1,208
have you thought of maybe doing this table in excel so that you can preform the calculations and then link that spread sheet into Access so it acts like a table?
Jul 18 '07 #2

P: 25
have you thought of maybe doing this table in excel so that you can preform the calculations and then link that spread sheet into Access so it acts like a table?

that's something i have to do as a weekly report, and i wanted for it to be as automated as possible. besides i have typically between 70k to 110k line items that will not "fit" in excel... thanks for suggestion tho.
Jul 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.