Thank you, I did not know this.

I also know other experienced developers who were not aware of this.

Please note the access query is incorrect!

It should be

UPDATE DISTINCTROW dbo_Employees INNER JOIN dbo_EmployeeTerritories ON dbo_Employees.EmployeeID = dbo_EmployeeTerritories.EmployeeID SET dbo_Employees.LastName = 'Leverling'

WHERE (((dbo_Employees.EmployeeID)=3));

This will only select records with EmployeeID =...

Hi Andy,

How about changing the query from

UPDATE dbo_Employees INNER JOIN dbo_EmployeeTerritories ON dbo_Employees.EmployeeID = dbo_EmployeeTerritories.EmployeeID SET dbo_Employees.LastName = "Leverling2"

WHERE (((dbo_EmployeeTerritories.EmployeeID)=3));

to

UPDATE DISTINCTROW dbo_Employees INNER JOIN dbo_EmployeeTerritories ON dbo_Employees.EmployeeID = dbo_EmployeeTerritories.EmployeeID SET...

Sorry small error, left in the literal 'MyPivot' instead of @Pivot.

USE Tempdb

GO

--Create the Data

IF OBJECTPROPERTY(OBJECT_ID('dbo.MyData'), 'IsUserTable') = 1

  DROP TABLE dbo.MyData;

GO

CREATE TABLE dbo.MyData

(

 ID    INT   NOT NULL

, LastName  VARCHAR(20) NOT NULL

,...

I have added the dynamic element you need, hopefully this will be closer to what you need.

Youwill need to know the name of the field which uniquely identifies each row...

Does this work for you?

USE tempdb

IF OBJECTPROPERTY(OBJECT_ID('dbo.MyPivot'), 'IsUserTable') = 1

  DROP TABLE dbo.MyPivot;

GO

CREATE TABLE dbo.MyPivot

(

 ID    INT   NOT NULL

, LastName  VARCHAR(20) NOT NULL

, FirstName  VARCHAR(20) NOT NULL

, Gender  CHAR(1)  NOT NULL

, Age   TINYINT  NOT NULL

);

GO

INSERT INTO MyPivot VALUES (1, 'Smith','Joe','M',32)

INSERT INTO MyPivot VALUES...

Scott,

The quickest way is to open up each Access Database as a user and click on

Tools-Analyze-Documentor menu.

Select the appropriate options for each database object.

This will present an Access Style report...