Hi,
New here, trying to complete a work assignment and not having much luck.
I have a database with a column of numerical data [Layer #] that indicates a level above ground for a sampling port. There are 32 ports with multiple ports in each layer #. The actual height above ground ([Layer Ht]) that corresponds to the layer # changes over time. I'm trying to update the databases to reflect the correct height in m of each port according to its layer #. I am receiving a Duplicate output destination error and do not know how to restructure the query to avoid this. Here is a sample of the query that I am attempting:
UPDATE [Ring 2] SET [Ring 2].[Layer Height] = 0.25, [Ring 2].[Layer Height] = 1, [Ring 2].[Layer Height] = 4, [Ring 2].[Layer Height] = 7
WHERE ((([Ring 2].Date)<#2/1/2010#) AND ([Layer #]=1) AND ([Layer #]=2) AND ([Layer#]=3) AND ([Layer#]=4));
Any help is greatly appreciated!
New here, trying to complete a work assignment and not having much luck.
I have a database with a column of numerical data [Layer #] that indicates a level above ground for a sampling port. There are 32 ports with multiple ports in each layer #. The actual height above ground ([Layer Ht]) that corresponds to the layer # changes over time. I'm trying to update the databases to reflect the correct height in m of each port according to its layer #. I am receiving a Duplicate output destination error and do not know how to restructure the query to avoid this. Here is a sample of the query that I am attempting:
UPDATE [Ring 2] SET [Ring 2].[Layer Height] = 0.25, [Ring 2].[Layer Height] = 1, [Ring 2].[Layer Height] = 4, [Ring 2].[Layer Height] = 7
WHERE ((([Ring 2].Date)<#2/1/2010#) AND ([Layer #]=1) AND ([Layer #]=2) AND ([Layer#]=3) AND ([Layer#]=4));
Any help is greatly appreciated!