S
Simon Jester
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
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