If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

so design your report
specify the sorting and grouping to be by employee
in the group footer put in two control boxes
set the data source to be
=count(cstmr) for one
= sum(sales) for the other

set a report footer and two controls, set the data source to be the same

then consioder how you limit the data
you could set the reports query to limit the data to say
WHERE salesdate = date() -1
but that would only work when you run the report the day following the sales date
you would be better of if you parameterised the report and supplied that as part of the form that calls the report as part of the openreport argument.

by setting the the date limit as part of the openreport you have a single report which could be used to report a single day, or a specific time period (say a week, month or quarter).

you could also specify the date limit in the query design

eg
where orderDate between [Lower Date Limit] and [Upper Date Limit]

however I dislike that method as its not possible to make certain the user puts in correct data. I far prefer to use a form that calls reports with specified values, another form that sets those values, and handles the validation logic