Ok, I'll try to explain as best as I can. I am a noob and I am only in the
learning process.. I am creating an app for scheduling.

The scheduling is for employees to follow from their employers. What I am
trying to do is for an administrator access to the app to be able to click on
"View Schedules" and see a calendar (already got the calendar btw) and for each
date there would be employee(s) that would be scheduled for that day. They will
then be able to click on it and a pop up will come up with more details.

Anyways the problem is the SQL query. Right now I have it where if you do
this.. you will see all the employees that have been scheduled. (I've tested it
out with 5 names). So if you do this you will see all 5 names, plus how many
times they have been scheduled.

Ex.:

John Doe 1 (1/2/05-1/5/05) --> this would be the dates that John Doe is
scheduled to work.
John Doe 2 ""
John Doe 3 ""
John Doe 4 ""

John Doe 1(4/1/05 - 4/10/05)

So above is a simple example of John Doe's scheduled for those dates, and John
Doe 1 was scheduled again. ON the calendar.. right now I am viewing April and
this is what shows on EVERY day, including all past months and previous months.

John Doe 1
John Doe 2
John Doe 3
John Doe 4
John Doe 5
John Doe 1

I would post my query, but I'm just working with a query to get the info
because all past queries didn't work. I think all I need a good WHERE clause.
This way it view on the calendar only those who are scheduled for that
particular day and doesn't copy them like they were above by ID# or dates or
anything.. it should view only if they are scheduled that day and order by name.

Oh yes.. and the "add" fields are sch_day_from (no brainier) and
sch_day_to(yet another no brainier) -- > these are the fields for the dates.