I have a query now that pulls records between 2 dates the user inputs on a form. The records have a Branch field, and a dollar amount field. I need a query to count how many of each branch shows up and sum the dollar amount for that branch. For example branch A shows up 5 times with a sum amount of $5,000, and so on down the line. Does this make sense, I think I confused myself.
Can this be done in a query? I have use dsum and dcount before and could use that but there are hundreds of different branches and some of them wont have any records and I don't want them to show up. I think there is an easier way to calculate all this than that. Or some kind of vba code to loop through everything. Im at a loss right now on how to do this.
Can this be done in a query? I have use dsum and dcount before and could use that but there are hundreds of different branches and some of them wont have any records and I don't want them to show up. I think there is an easier way to calculate all this than that. Or some kind of vba code to loop through everything. Im at a loss right now on how to do this.
