You have the horse before the cart. You cannot write SQL that is useful until you establish the proper table structure. And the query builder in Access will do a very nice job of helping you with the SQL statement once you have the tables designed and some data in them. Also note that Access SQL is different from T-SQL which is different from ANSI SQL, so unless you take a course in writing Access SQL, you will find writing it in SQL mode much more difficult than using the designer.