Trying to access a total and display it on a front page

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 !

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!