aggregate function DSUM

[sanjusm]

Hi All,

I have a table namely, leave_details wherein there is a column called DAYS and TDAYS,
DAYS columns represent number of leaves an employee has taken in a single leave application and
TDAYS represents Total number of leaves an employee has availled till date.

To calculate the TDAYS i need to SUM the DAYS column for every employee.

When an employee again log in the application he should be aware of the total number of leaves which he has already availed.

Please help me for the same as I am unable to do so.

Kindly revert back for any queries or any further information.

With Warm Regards,
Sanjay

 

[bloomy555]

Hi All,

I have a table namely, leave_details wherein there is a column called DAYS and TDAYS,
DAYS columns represent number of leaves an employee has taken in a single leave application and
TDAYS represents Total number of leaves an employee has availled till date.

To calculate the TDAYS i need to SUM the DAYS column for every employee.

When an employee again log in the application he should be aware of the total number of leaves which he has already availed.

Please help me for the same as I am unable to do so.

Kindly revert back for any queries or any further information.

With Warm Regards,
Sanjay

I am not sure that I have understood your problem clearly.

you said there are 2 columns in your table.....aren't there any columns that represent employee's name, ID...? or what? ???

 

[sanjusm]

yes there are other columns also [resent that is.
EMPID number
EMPNAME text
SDATE date
EDATE date

 

[bloomy555]

yes there are other columns also [resent that is.
EMPID number
EMPNAME text
SDATE date
EDATE date

I am not getting the format of your table is it like this:

EMPID EMPNAME SDATE EDATE TDAYS DAYS


You said first there are 2 columns in your table..now you are saying there are others?!!!!!!!11