Your beginner training covers 1 query but I need to create an employee database and possibly a nurse licensing database for those employees and somehow query them together to track expiration dates and make sure they get new licenses when expired. I'm having difficulty in creating the queries from 2 different tables. Could you give a quick help on this?

---

Reply from Richard Rost:

By "query them together" do you mean MERGE the data from two tables into one set of records? If so, you need a UNION query, which is a little more advanced. I probably won't be covering that until the EXPERT series... but I've already covered it in my Access 2003 classes. It works almost exactly the same. I covered it in Access 223. If you REALLY want to learn about queries, I also have a 3-class series called the SQL Seminar. I cover everything there is to know about queries in SQL. UNION queries are covered in Part 1.