Count and display different services

From: Simon Jester (SimonJester_at_moose-mail.com)
Date: 11/23/04 

Date: 23 Nov 2004 10:26:43 -0800

Would be very grateful if someone could help me out with this problem:

I have created a form based on a query. The form is supposed to
display the clerk's name, store name, beginning and ending dates of a
given date range and 12 different service names and the total number
of times the clerk provided each service.

The query asks for the clerks name, store ID, and the beginning and
ending dates. The query also counts the number of times each of the
12 service names appears.
So far, so good.

The problem is:
The results display the each service name and the count of each
service. Unfortunately, it also displays the clerk, store name, and
beginning and ending dates - for each different service name and
total.
 
What I want to see is the name, store name, and beginning and ending
dates one time only, then a list of each service and its total.

On my form I have one field for the name, store, date range. Below
that I have fields for each of the 12 possible services and a field
for the total of each. When I open the form it displays the name,
store, and date range the way I want, but it repeats the the first
service and total in all 12 service name fields and total fields.

I'm a rookie at this obviously and would sure appreciate help.
Thanks very much for your time,
SJ

Relevant Pages

  • Re: Populating fields from a separate table
    ... You don't need store the existing data in the second table, ... To display the data create a query with Table two and table one as the ... set the join type to a left join on the 3 digit column. ...
    (comp.databases.ms-access)
  • Involved query / possible over Access assistance.
    ... This is the idea I want to try to implement in an access database. ... I want to store the dayof the week that the event ... I want to then do a query for a given week. ... point during the week 1) display which dayof the week, ...
    (microsoft.public.access.queries)
  • Re: Access combo box-show name, not ID, in table?
    ... created a record you would store that person's name. ... Now use the Combo Box Wizard to create a combo box to find a record ... Now that you have a form, you can make a query based on the form's Record ... >> what table to open etc...but provide a nice menu that opens up a nice form. ...
    (microsoft.public.access.gettingstarted)
  • Re: Query to show top x% by group
    ... Next query mean you have to establish a Running Sum for the stores. ... SELECT Store, Sumas RunningTotal ...     FROM YourTable) ... I have a query that counts the number of occurrences of a given event, ...
    (microsoft.public.access.queries)
  • Re: Need Form and TextBox Help
    ... for that store, DM etc.... ... I am in need of advice on this one...In the ResumeDates table I was ... Then I have to think about the query I would run for the reporting ... Tracking Number - recorded in ISS table ...
    (microsoft.public.access.forms)