calculation query....

[helpneededuk]

I am trying to set up a query so that I can calulate commission due each monht.

I then need to place this as a subform within the main employee form.

How can i achive this?

 

[fredericofonseca]

First you setup a select statement that perform the operation you need.

Then you go to the form you need and add it to a sub-form..

After doing the above if you have specific problems come back to us with your code and what you have attempted to do and we will help on what we can.
The form bit will require more information from you.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[helpneededuk]

select statement -

I have an employee table include employee details etc and a commission table containing: commissionID, EmployeeID, CommissionAllocated, CommissionPaidOut, Date, Target.

how do i set up a select statement?

 

[fredericofonseca]

Easy. Read your manuals. Plenty of them available, and if you don't know how to do a SELECT then you really need to read them even before you try and do any forms.


If you are using Access it will have a online system with some help and some examples you can use.

If you are using SQL Server then look at the supplied books online.

And there are plenty of SQL books out there, both online and on public libraries and on shopos.

Get one and read it.

also if yo search these forums you will find plenty of threads with "select" SQL statements on them.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com