Error 3079-

  • Thread starter Thread starter misschanda via AccessMonster.com
  • Start date Start date
M

misschanda via AccessMonster.com

Hello,
I am getting the error that says the specific field [product number] could
refer to more than one table listed in the form clause of your statement.
Here is the from statement of the SQL..

FROM [New Product Design Input Form Target] INNER JOIN [The New Design OutPut
Form] ON [New Product Design Input Form Target].[Product Number] = [The New
Design OutPut Form].[Product Number];

How could this be fixed.

Thanks in Advanced
LA
 
It would help if you posted the entire SQL. But I am guessing that
somewhere in your SELECT clause or your WHERE Clause you have referred to
Product Number without qualifying it with the table name. Perhaps in a
calculation of some type.

SELECT Left([Product number],5) , ...

Would generate the error since we can't tell from that which [Product
Number] field you want to use from the two tables/

The statement would have to be
SELECT Left([New Product Design Input Form Target].[Product Number],5) ...
to avoid any ambiguity.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Sorry,
Here is entire SQL


SELECT [New Product Design Input Form Target].[Applicable Statutory and
Regulatory Requirements], [New Product Design Input Form Target].[Product
Number], [New Product Design Input Form Target].[Product Type], [New Product
Design Input Form Target].[Size(mm)], [New Product Design Input Form Target].
[Development Spec Date], [New Product Design Input Form Target].[Key
Characteristics Notes1], [New Product Design Input Form Target].[Y Modules
(gm/den) Min1], [New Product Design Input Form Target].[Y Modules (gm/den)
Avg1], [New Product Design Input Form Target].[Y Modules (gm/den) Max1], [New
Product Design Input Form Target].[Toughness (gm/den) Min1], [New Product
Design Input Form Target].[Toughness (gm/den) Max1], [New Product Design
Input Form Target].[Tenacity (gm/den) Min1], [New Product Design Input Form
Target].[Tenacity (gm/den) Avg1], [New Product Design Input Form Target].
[Tenacity (gm/den) Max1], [New Product Design Input Form Target].[Dry Heat
Temp], [New Product Design Input Form Target].[Hydrolysis Temp], [New Product
Design Input Form Target].[Dry Heat Time to 80% Tensile], [New Product Design
Input Form Target].[Hydrolysis Time to 80% Tensile], [New Product Design
Input Form Target].Series, [The New Design OutPut Form].[Product Name], [The
New Design OutPut Form].[Size(mm)], [The New Design OutPut Form].[% Shrinkage
Avg], [The New Design OutPut Form].[% Relative Elong Avg], [The New Design
OutPut Form].[% Elong At Break Avg], [The New Design OutPut Form].[Tensile
Strength (lbs) Avg], [The New Design OutPut Form].[Knot Strength (lbs) Avg],
[The New Design OutPut Form].[Loop Strength (lbs) Avg], [The New Design
OutPut Form].[Y Modules (gm/den) Avg], [The New Design OutPut Form].
[Toughness (gm/den) Avg], [The New Design OutPut Form].[Tenacity (gm/den)
Avg], [The New Design OutPut Form].[Development Spec Date], [The New Design
OutPut Form].[Key Characteristics Notes1], [The New Design OutPut Form].[Dry
Heat Temp], [The New Design OutPut Form].[Hydrolysis Temp], [The New Design
OutPut Form].[Product Number], [The New Design OutPut Form].[Size(mm)], [New
Product Design Input Form Target].[Y Modules (gm/den) Avg1], [New Product
Design Input Form Target].[Tenacity (gm/den) Avg1], [New Product Design Input
Form Target].[Toughness (gm/den) Avg1], [The New Design OutPut Form].
[Tensile Strength (lbs) Min], [The New Design OutPut Form].[Knot Strength
(lbs) Min], [The New Design OutPut Form].[Loop Strength (lbs) Min], [The New
Design OutPut Form].[% Shrinkage Min], [The New Design OutPut Form].[%
Relative Elong Min], [The New Design OutPut Form].[% Elong At Break Min]
FROM [New Product Design Input Form Target] INNER JOIN [The New Design OutPut
Form] ON [New Product Design Input Form Target].[Product Number]=[The New
Design OutPut Form].[Product Number];


John said:
It would help if you posted the entire SQL. But I am guessing that
somewhere in your SELECT clause or your WHERE Clause you have referred to
Product Number without qualifying it with the table name. Perhaps in a
calculation of some type.

SELECT Left([Product number],5) , ...

Would generate the error since we can't tell from that which [Product
Number] field you want to use from the two tables/

The statement would have to be
SELECT Left([New Product Design Input Form Target].[Product Number],5) ...
to avoid any ambiguity.
Hello,
I am getting the error that says the specific field [product number] could
Click to expand...
[quoted text clipped - 11 lines]
Thanks in Advanced
LA
Click to expand...
Click to expand...
 
SELECT
[New Product Design Input Form Target].[Applicable Statutory and
Regulatory Requirements]
, [New Product Design Input Form Target].[Product Number]
, [New Product Design Input Form Target].[Product Type]
, [New Product Design Input Form Target].[Size(mm)]
, [New Product Design Input Form Target].[Development Spec Date]
, [New Product Design Input Form Target].[Key Characteristics Notes1]
, [New Product Design Input Form Target].[Y Modules (gm/den) Min1]
, [New Product Design Input Form Target].[Y Modules (gm/den) Avg1]
, [New Product Design Input Form Target].[Y Modules (gm/den) Max1]
, [New Product Design Input Form Target].[Toughness (gm/den) Min1]
, [New Product Design Input Form Target].[Toughness (gm/den) Max1]
, [New Product Design Input Form Target].[Tenacity (gm/den) Min1]
, [New Product Design Input Form Target].[Tenacity (gm/den) Avg1]
, [New Product Design Input Form Target].[Tenacity (gm/den) Max1]
, [New Product Design Input Form Target].[Dry Heat Temp]
, [New Product Design Input Form Target].[Hydrolysis Temp]
, [New Product Design Input Form Target].[Dry Heat Time to 80% Tensile]
, [New Product Design Input Form Target].[Hydrolysis Time to 80% Tensile]
, [New Product Design Input Form Target].Series
, [The New Design OutPut Form].[Product Name]
, [The New Design OutPut Form].[Size(mm)]
, [The New Design OutPut Form].[% Shrinkage Avg]
, [The New Design OutPut Form].[% Relative Elong Avg]
, [The New Design OutPut Form].[% Elong At Break Avg]
, [The New Design OutPut Form].[Tensile Strength (lbs) Avg]
, [The New Design OutPut Form].[Knot Strength (lbs) Avg]
, [The New Design OutPut Form].[Loop Strength (lbs) Avg]
, [The New Design OutPut Form].[Y Modules (gm/den) Avg]
, [The New Design OutPut Form].[Toughness (gm/den) Avg]
, [The New Design OutPut Form].[Tenacity (gm/den) Avg]
, [The New Design OutPut Form].[Development Spec Date]
, [The New Design OutPut Form].[Key Characteristics Notes1]
, [The New Design OutPut Form].[Dry Heat Temp]
, [The New Design OutPut Form].[Hydrolysis Temp]
, [The New Design OutPut Form].[Product Number]
, [The New Design OutPut Form].[Size(mm)]
, [New Product Design Input Form Target].[Y Modules (gm/den) Avg1]
, [New Product Design Input Form Target].[Tenacity (gm/den) Avg1]
, [New Product Design Input Form Target].[Toughness (gm/den) Avg1]
, [The New Design OutPut Form].[Tensile Strength (lbs) Min]
, [The New Design OutPut Form].[Knot Strength (lbs) Min]
, [The New Design OutPut Form].[Loop Strength (lbs) Min]
, [The New Design OutPut Form].[% Shrinkage Min]
, [The New Design OutPut Form].[% Relative Elong Min]
, [The New Design OutPut Form].[% Elong At Break Min]
FROM [New Product Design Input Form Target]
INNER JOIN [The New Design OutPut Form]
ON [New Product Design Input Form Target].[Product Number]=
[The New Design OutPut Form].[Product Number];

Wow what nice long table and field names. It appears to me that your
query may be based on other queries. I don't even want to see them.

IF you are using other queries as the basis for this query, you may need
to check them and make sure that they aren't causing the problem. You
could try dropping one table(Query?) from this one and see if it runs.
If so, then try with the other table(query?) and see if it runs.

Also, look for any filter or sorting you applied through the data sheet
interface. That could be the cause of the problem.

Try Copying the SQL into a new blank query and see if that runs. If so,
save the new query and dispose of the old one.
'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


misschanda via AccessMonster.com wrote:
 
thanks.
LA
John said:
SELECT
[New Product Design Input Form Target].[Applicable Statutory and
Regulatory Requirements]
, [New Product Design Input Form Target].[Product Number]
, [New Product Design Input Form Target].[Product Type]
, [New Product Design Input Form Target].[Size(mm)]
, [New Product Design Input Form Target].[Development Spec Date]
, [New Product Design Input Form Target].[Key Characteristics Notes1]
, [New Product Design Input Form Target].[Y Modules (gm/den) Min1]
, [New Product Design Input Form Target].[Y Modules (gm/den) Avg1]
, [New Product Design Input Form Target].[Y Modules (gm/den) Max1]
, [New Product Design Input Form Target].[Toughness (gm/den) Min1]
, [New Product Design Input Form Target].[Toughness (gm/den) Max1]
, [New Product Design Input Form Target].[Tenacity (gm/den) Min1]
, [New Product Design Input Form Target].[Tenacity (gm/den) Avg1]
, [New Product Design Input Form Target].[Tenacity (gm/den) Max1]
, [New Product Design Input Form Target].[Dry Heat Temp]
, [New Product Design Input Form Target].[Hydrolysis Temp]
, [New Product Design Input Form Target].[Dry Heat Time to 80% Tensile]
, [New Product Design Input Form Target].[Hydrolysis Time to 80% Tensile]
, [New Product Design Input Form Target].Series
, [The New Design OutPut Form].[Product Name]
, [The New Design OutPut Form].[Size(mm)]
, [The New Design OutPut Form].[% Shrinkage Avg]
, [The New Design OutPut Form].[% Relative Elong Avg]
, [The New Design OutPut Form].[% Elong At Break Avg]
, [The New Design OutPut Form].[Tensile Strength (lbs) Avg]
, [The New Design OutPut Form].[Knot Strength (lbs) Avg]
, [The New Design OutPut Form].[Loop Strength (lbs) Avg]
, [The New Design OutPut Form].[Y Modules (gm/den) Avg]
, [The New Design OutPut Form].[Toughness (gm/den) Avg]
, [The New Design OutPut Form].[Tenacity (gm/den) Avg]
, [The New Design OutPut Form].[Development Spec Date]
, [The New Design OutPut Form].[Key Characteristics Notes1]
, [The New Design OutPut Form].[Dry Heat Temp]
, [The New Design OutPut Form].[Hydrolysis Temp]
, [The New Design OutPut Form].[Product Number]
, [The New Design OutPut Form].[Size(mm)]
, [New Product Design Input Form Target].[Y Modules (gm/den) Avg1]
, [New Product Design Input Form Target].[Tenacity (gm/den) Avg1]
, [New Product Design Input Form Target].[Toughness (gm/den) Avg1]
, [The New Design OutPut Form].[Tensile Strength (lbs) Min]
, [The New Design OutPut Form].[Knot Strength (lbs) Min]
, [The New Design OutPut Form].[Loop Strength (lbs) Min]
, [The New Design OutPut Form].[% Shrinkage Min]
, [The New Design OutPut Form].[% Relative Elong Min]
, [The New Design OutPut Form].[% Elong At Break Min]
FROM [New Product Design Input Form Target]
INNER JOIN [The New Design OutPut Form]
ON [New Product Design Input Form Target].[Product Number]=
[The New Design OutPut Form].[Product Number];

Wow what nice long table and field names. It appears to me that your
query may be based on other queries. I don't even want to see them.

IF you are using other queries as the basis for this query, you may need
to check them and make sure that they aren't causing the problem. You
could try dropping one table(Query?) from this one and see if it runs.
If so, then try with the other table(query?) and see if it runs.

Also, look for any filter or sorting you applied through the data sheet
interface. That could be the cause of the problem.

Try Copying the SQL into a new blank query and see if that runs. If so,
save the new query and dispose of the old one.
'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
Click to expand...
 
Back
Top