I tried it however I am getting this error:

Reserved error (-3025); there is no message for this error.

Ho can I resolve this issue?

ok thank you. I've transferred everthing to the Ms Access section.

Thank you.

First of all thank you for your help.

The layout of the code you provided is much more easiers to read.

In the front end I am trying to create a form...

I was trying to pass the Staff_Id and the Lesson_Date as a parameter to get all the appointments for that instructor for that day.

I will rewrite it instead in nested select statements and see if it works.

No. It's saying Syntax error on Join operation. I am working with Microsoft Access.

After clicking ok on the syntax error it automatically highlights the (Session_Information Join.

Thank you so much.

This code worked perfectly.

SELECT Top 1

[Booking].[Staff_Id] ,

...