Dear Martin:

The fundamental difficulty here is that you have repeated the date and price
columns 10 times.  A properly constructed database would have only one date
and price value per row.

You can temporarily overcome this by creating the appearance that your data
were stored properly.  This can be done by a normalizing UNION query:

SELECT LastName, FirstName, "01" as Service, Date01, Price01
 FROM YourTable
 WHERE Date01 IS NOT NULL
UNION ALL
SELECT LastName, FirstName, "02" as Service, Date02, Price02
 FROM YourTable
 WHERE Date02 IS NOT NULL

repeat this till you have all 10 date/price combinations.  You must correct
the column and table names I have assigned, as I don't know exactly how you
have done this.

You can then easily query the above to show only those rows belonging to the
user defined period.

A grand total can also be produced using a separate query, or as a total on
a report.

Tom Ellison