B
Bayou BoB
I posted last night regarding the trouble I was having with a query
I've built. I neglected to send the actual query.
As you may have read (or if this is the first time) my query is based
on a medical attention log. The table itself is as such:
MedicalAttentionID (primary key)
EmployeeID
ClientID
ActDate
MedActivityID
TimeID
obviously the "*ID" fields are all related to other tables in which
the user can select their choice.
For the query, it only returns results if ALL of the fields have
something in them. I have some sample data in the table...and all
fields are required EXCEPT the ClientID since there are some tasks
that don't require a client to be involved. The query itself ONLY
returns entries in the table that have ALL of the fields filled in. On
the entries with no clientID, they simply don't show up. I'm not sure
how to fix this? I"ve tried many different options (though my
knowledge is slim) and have been having no success. You may see right
away what I'm missing....so I thank you in advance. Here is the sql
view of my query that I'm talking about....
SELECT MedicalAttentionLog.ActDate, CLI_Names.LastName AS
CLI_Names_LastName, CLI_Names.FirstName AS CLI_Names_FirstName,
Time.[Time Spent], EMP_Names.LastName AS EMP_Names_LastName,
EMP_Names.FirstName AS EMP_Names_FirstName, MedActivityID.MedActivity,
MedicalAttentionLog.ClientID, MedicalAttentionLog.EmployeeID,
MedicalAttentionLog.MedActivityID, MedicalAttentionLog.TimeID
FROM [Time] INNER JOIN (MedActivityID INNER JOIN (EMP_Names INNER JOIN
(CLI_Names INNER JOIN MedicalAttentionLog ON
CLI_Names.ClientID=MedicalAttentionLog.ClientID) ON
EMP_Names.EmployeeID=MedicalAttentionLog.EmployeeID) ON
MedActivityID.MedActivityID=MedicalAttentionLog.MedActivityID) ON
Time.TimeID=MedicalAttentionLog.TimeID;
Thanks very much for having a look in advance!!
Kevin
I've built. I neglected to send the actual query.
As you may have read (or if this is the first time) my query is based
on a medical attention log. The table itself is as such:
MedicalAttentionID (primary key)
EmployeeID
ClientID
ActDate
MedActivityID
TimeID
obviously the "*ID" fields are all related to other tables in which
the user can select their choice.
For the query, it only returns results if ALL of the fields have
something in them. I have some sample data in the table...and all
fields are required EXCEPT the ClientID since there are some tasks
that don't require a client to be involved. The query itself ONLY
returns entries in the table that have ALL of the fields filled in. On
the entries with no clientID, they simply don't show up. I'm not sure
how to fix this? I"ve tried many different options (though my
knowledge is slim) and have been having no success. You may see right
away what I'm missing....so I thank you in advance. Here is the sql
view of my query that I'm talking about....
SELECT MedicalAttentionLog.ActDate, CLI_Names.LastName AS
CLI_Names_LastName, CLI_Names.FirstName AS CLI_Names_FirstName,
Time.[Time Spent], EMP_Names.LastName AS EMP_Names_LastName,
EMP_Names.FirstName AS EMP_Names_FirstName, MedActivityID.MedActivity,
MedicalAttentionLog.ClientID, MedicalAttentionLog.EmployeeID,
MedicalAttentionLog.MedActivityID, MedicalAttentionLog.TimeID
FROM [Time] INNER JOIN (MedActivityID INNER JOIN (EMP_Names INNER JOIN
(CLI_Names INNER JOIN MedicalAttentionLog ON
CLI_Names.ClientID=MedicalAttentionLog.ClientID) ON
EMP_Names.EmployeeID=MedicalAttentionLog.EmployeeID) ON
MedActivityID.MedActivityID=MedicalAttentionLog.MedActivityID) ON
Time.TimeID=MedicalAttentionLog.TimeID;
Thanks very much for having a look in advance!!
Kevin