I have created a holiday form to use on a Intranet.
The form saves the following fields into tblHolidays
ID, User_id, Date_requested, duration
In another table (tblUserdetails) i have a matching User_id and allocated_holidays.
On my home page I want to display somthing like
the first field needs to be a sum of all tblHolidays.duration matching a individual tblHolidays.User_id
You have taken xx number of holidays from xx allocated.
You xx of xx holdaiys left
If some one can help that would be great !