Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Access 2010 SQL Aggregate Functions Help!

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
This is my first posting on here. I have a form that Nursing leaders can use to select a month from a combo box and see the number of people who have seen patients in a month. Basically I want to change the query to add the total number of each person who rounded and then give a percentage of the total. Here is a copy of my SQL for the query.
SELECT tblPatient.DateofRounding, [tblNurse Rounding Leader].NRLLastName, [tblNurse Rounding Leader].NRLFirstName
FROM [tblNurse Rounding Leader] INNER JOIN tblPatient ON [tblNurse Rounding Leader].[Nurse Rounding LeaderID] = tblPatient.fk_LeaderInitials
WHERE (((Month([DateofRounding]))=[Forms]![frmMain_expandlg]![Subform1]![cboMonthRPT]));
P.S. The names of the forms are strange from the GUI Menu I use.
  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP