Ars Technica

SQL Queries in Access 2000 - creating a report that contains remote & local data

Once again I've run into uncharted waters. The captain suggested that it might be prudent to hail Ars, to see if they had any advice.<BR><BR>I've got a report which requires data from the local ...
Ars Technica

Creating a temporary table in Access 2003 from a recordset in SQL Server 2000

My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to run ...
TechRepublic

Rename fields to make your Access queries more meaningful

When working in Access, it may be helpful to change the field name of an older query so that the report or form is more meaningful. For example, suppose you have a patient database that includes a ...
TechRepublic

Use a query to count specific Access records

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. The Count function helps you easily create a query ...