Counting different selections in query

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Creating a Chart on form from selected data in query. 0
SUM in a UNION query 2
Query producing different results each time it is run 2
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Counting multiple field values in a single query/report 2
Count and assign 2
Group my month and then total each location - query 2

Top