I suck at this stuff, but if I could figure out a query it would prevent me from going through about 30K lines of garbage and doing this manually. I've got a table in Access where I would like to look at a column of Vendor ID's. When the vendor ID changes I would like to total up all the Expenses for that Vendor, then move on to the next Vendor ID. Anyone know how would i go about this?
For example, i could have 50 rows with the same vendor ID. When the ID changes I want my query to produce one row with that Vendor ID, the total of the expenses, and the name, address, etc.