Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: aggregate function

    I have three tables, tblschedule, tblresource and tblemployeename.
    in tblschedule table there are scheduleID, resourceID and employeeID. In tblResource there are ResourceID and ResourceName. In tblemployeename there are EmployeeID, EmployeeFName and EmployeeLame. I want to have a report that show how many times the resource has been reserved by employee. i would like to have a report. Look like the following:

    ResourceName EmployeeFName EmployeeLName (Or use EmployeeName) Number of record.

    How to write a query? I use asp.net as front end.

    Thank for your help.

  2. #2
    Join Date
    Nov 2002
    Posts
    272
    The aggregate function you are looking for is Count().

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •