Relationships link one Table to another. This article explains how to Create, Edit and Delete a Table Relationship in Microsoft Access.

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.

You can query across databases in Oracle and Sql Server, with a little work. I'm not sure about access. <BR>It really would be easier to just link the tables I would think.

That article includes a simple query for extracting data for customers who live in a particular state or province. In this article, we look at writing more advanced queries, and how you can format and ...

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it.