Counting different selections in query

  • Thread starter Thread starter freederek
  • Start date Start date
F

freederek

I have an Access database where the users select whether their account is a
Legacy account or a business as usual(BAU) and these are fed into a master
sheet from the data input query. In another Query I count the total number of
accounts and the total value of these accounts by each user. How can I make
the query split these totals based on the selection of Legacy or BAU?? i.e:
 
Back
Top