select count by group?

Is it possible in access to select the total count of records for a
given group of records and show those all those counts in one report?
For example, I have a table of records that contain different customers
with different service requests. I would like to build a report that
shows the quantity of service requests for each customer and then maybe
later, by type of service request for each customer. Fields are
CustomerName, ServiceRequestDate, Type. I can use the query builder and
know a little SQL and I can make a report for each customer with the
count in it, but all I'm really interested in is the count for each
customer, hopefully on 1 report? Thanks for any help....

.

Relevant Pages

  • Abuse report
    ... This is an automated response to the email you sent to the BT Customer ... All cases of abuse are taken very seriously. ... please report abuse where someone using a BT domain or a BT IP ... directly to the offender's Internet Service Provider. ...
    (uk.rec.motorcycles)
  • Re: Help ... Creating an invoice
    ... So what you will want is a query that will return the required information ... for a report to use. ... for just the records for that customer. ... > if I want that order to be placed on the invoice? ...
    (microsoft.public.access.forms)
  • Re: move data from list box or combo box to another list
    ... employees is because each employee gets paid commission on the service they ... The customer and dates are ... Lets address your problem with your report which seems to be your main ... Oh yeah and also you should/could have a filter in your query so that your ...
    (microsoft.public.access.forms)
  • Re: DBForms convert Access db and forms from Access to PHP + Mysql
    ... After conversion you'll have to use PHP tools, AJAX and work with MySql. ... say hey here's some great report writer that works with mySql. ... taking orders from a customer. ...
    (comp.databases.ms-access)
  • Re: Have date automatically go into another form
    ... i have created a report from the table in which i have diffrent customers ... i.e if for example i need to see the reports of the customer who have made a ... On Error GoTo Err_ ButtonNname _Click ... Dim stDocName As String ...
    (microsoft.public.access.gettingstarted)