Summary on a form

[Alan T]

Hi,

I got a form link to a table: tblSalesman.
On the bottom of the form I want to show the summary of the orders that made
by the salesman when I select the record selector.

2 tables I have:
1) tblSalesman
- EmployeeNo
- FirstName
- LastName
- DateJoined

2) tblSales
- OrderNo
- OrderDate
- Qty
- Price
- EmployeeNo

I put text boxes for EmployeeNo, FirstName, LastName and DateJoined on the
top of the form to show the details of each salesman, it's OK now when I
press the record navigator.
However, I also want to show the total of the orders that this salesman
made, eg.
SELECT EmployeeNo, SUM(Qty*Price) As TotalOrder
FROM tblSales
GROUP BY EmployeeNo

If I put a text box at the bottom, how do I link to the form's data so that
when I press the record navigator to browse each salesman, it also shows the
total sales that 'this' salesman made?

 

[Jeff Boyce]

Alan

Take a look in Access HELP for the DCount() command. You could use that as
a source for your textbox.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/