Microsoft Access is a powerful database that is part of the Microsoft Office package, and by combining its user-friendly interface with the flexibility of SQL (Structured Query Language), you can ...

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...