Howdy, Stranger!

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

Categories

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.
or
You xx of xx holdaiys left

If some one can help that would be great !


Comments

  • Andre YoungAndre Young USAMember Posts: 0

    ________ ( http://forcoder.org ) free video tutorials and ebooks about || JavaScript, Swift, PHP, Scratch, R, Ruby, Delphi, C++, Python, Objective-C, Visual Basic, Assembly, Visual Basic .NET, MATLAB, PL/SQL, Java, C#, Perl, Go, C Clojure, Scheme, Logo, Apex, ML, Prolog, Lisp, Awk, Scala, Erlang, SAS, Fortran, F#, Transact-SQL, ABAP, Rust, Julia, Kotlin, Bash, D, VBScript, LabVIEW, FoxPro, Alice, Lua, Ada, COBOL, Crystal, Hack, Dart || ______________

Sign In or Register to comment.