Please, can you have me take a look at the code and tell me where I missed it. The information is displayed on a calendar box of the date. If use it to strip 5 letters of a doctor and the time the doctor has an appointment with a patient. This SQL String Listed above works perfect on Access 2016. & "WHERE (((tblAppointments.AppointDate)>=Date())) " & "FROM tblSchedule INNER JOIN tblAppointments ON tblSchedule.DoctorsID = tblAppointments.DoctorsID " _ StrQuery = "SELECT tblAppointments.AppID, tblAppointments.AppointDate, tblAppointments.AppointTime, Left(.,5) AS Doctor, tblSchedule.DoctorsName" _
0 Comments
Leave a Reply. |