D
Daniel
Hello,
I am still a novice with SQL and am trying to figure out how I can combine
the following 2 queries into 1 using a subquery. As you can see, 'qry_New
Client Appt Info' is built upon 'qry_Num of Appt by Client'.
qry_Num of Appt by Client
*******************
SELECT [tbl_Client Apptointments].ClientID, Count([tbl_Client
Apptointments].ApptDate) AS CountOfApptDate
FROM [tbl_Client Apptointments]
GROUP BY [tbl_Client Apptointments].ClientID;
qry_New Client Appt Info
******************
SELECT [tbl_Client Apptointments].ApptDate
FROM [qry_Num of Appt by Client] LEFT JOIN [tbl_Client Apptointments] ON
[qry_Num of Appt by Client].ClientID = [tbl_Client Apptointments].ClientID
WHERE ((([qry_Num of Appt by Client].CountOfApptDate)=1));
Your guidance is greatly appreciated.
Daniel P
I am still a novice with SQL and am trying to figure out how I can combine
the following 2 queries into 1 using a subquery. As you can see, 'qry_New
Client Appt Info' is built upon 'qry_Num of Appt by Client'.
qry_Num of Appt by Client
*******************
SELECT [tbl_Client Apptointments].ClientID, Count([tbl_Client
Apptointments].ApptDate) AS CountOfApptDate
FROM [tbl_Client Apptointments]
GROUP BY [tbl_Client Apptointments].ClientID;
qry_New Client Appt Info
******************
SELECT [tbl_Client Apptointments].ApptDate
FROM [qry_Num of Appt by Client] LEFT JOIN [tbl_Client Apptointments] ON
[qry_Num of Appt by Client].ClientID = [tbl_Client Apptointments].ClientID
WHERE ((([qry_Num of Appt by Client].CountOfApptDate)=1));
Your guidance is greatly appreciated.
Daniel P