specified field error

G

Guest

I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.

Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is
Null,[DateProcessed],(","+[TableLetter]))

How do I have the [DateProcessed] be selected from the table "Update Table"?
 
G

Guest

ReferenceNo3: ([Update Table].[DateProcessed]) & IIf([Update
Table].[DateProcessed] Is Null, [Update
Table].[DateProcessed],(","+[TableLetter]))
 
G

Guest

If I have a table, tableA, that has the same fields in it can I run an update
query to update the blank referenceno3 field in tableA. For instance the sql
returns 8/12/07,A in the update table and I want that to be put into the
tableA referenceno3 field.

KARL DEWEY said:
ReferenceNo3: ([Update Table].[DateProcessed]) & IIf([Update
Table].[DateProcessed] Is Null, [Update
Table].[DateProcessed],(","+[TableLetter]))

--
KARL DEWEY
Build a little - Test a little


Patrick said:
I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.

Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is
Null,[DateProcessed],(","+[TableLetter]))

How do I have the [DateProcessed] be selected from the table "Update Table"?
Click to expand...
Click to expand...
 
G

Guest

Post the complete query SQL.
--
KARL DEWEY
Build a little - Test a little


Patrick said:
If I have a table, tableA, that has the same fields in it can I run an update
query to update the blank referenceno3 field in tableA. For instance the sql
returns 8/12/07,A in the update table and I want that to be put into the
tableA referenceno3 field.

KARL DEWEY said:
ReferenceNo3: ([Update Table].[DateProcessed]) & IIf([Update
Table].[DateProcessed] Is Null, [Update
Table].[DateProcessed],(","+[TableLetter]))

--
KARL DEWEY
Build a little - Test a little


Patrick said:
I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.

Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is
Null,[DateProcessed],(","+[TableLetter]))

How do I have the [DateProcessed] be selected from the table "Update Table"?
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].[lot-bin#] = [test update
test fruit inventory].[lot-bin#], [test fruit inventory].DateProcessed =
[test update test fruit inventory].[DateProcessed], [test fruit
inventory].TableLetter = [test update test fruit inventory].[TableLetter];


KARL DEWEY said:
Post the complete query SQL.
--
KARL DEWEY
Build a little - Test a little


Patrick said:
If I have a table, tableA, that has the same fields in it can I run an update
query to update the blank referenceno3 field in tableA. For instance the sql
returns 8/12/07,A in the update table and I want that to be put into the
tableA referenceno3 field.

KARL DEWEY said:
ReferenceNo3: ([Update Table].[DateProcessed]) & IIf([Update
Table].[DateProcessed] Is Null, [Update
Table].[DateProcessed],(","+[TableLetter]))

--
KARL DEWEY
Build a little - Test a little


:

I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.

Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is
Null,[DateProcessed],(","+[TableLetter]))

How do I have the [DateProcessed] be selected from the table "Update Table"?
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

Try this ---
UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].DateProcessed = [test update
test fruit inventory].[DateProcessed], [test fruit inventory].TableLetter =
[test update test fruit inventory].[TableLetter]
WHERE [test fruit inventory].DateProcessed Is Null;

--
KARL DEWEY
Build a little - Test a little


Patrick said:
UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].[lot-bin#] = [test update
test fruit inventory].[lot-bin#], [test fruit inventory].DateProcessed =
[test update test fruit inventory].[DateProcessed], [test fruit
inventory].TableLetter = [test update test fruit inventory].[TableLetter];


KARL DEWEY said:
Post the complete query SQL.
--
KARL DEWEY
Build a little - Test a little


Patrick said:
If I have a table, tableA, that has the same fields in it can I run an update
query to update the blank referenceno3 field in tableA. For instance the sql
returns 8/12/07,A in the update table and I want that to be put into the
tableA referenceno3 field.

:

ReferenceNo3: ([Update Table].[DateProcessed]) & IIf([Update
Table].[DateProcessed] Is Null, [Update
Table].[DateProcessed],(","+[TableLetter]))

--
KARL DEWEY
Build a little - Test a little


:

I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.

Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is
Null,[DateProcessed],(","+[TableLetter]))

How do I have the [DateProcessed] be selected from the table "Update Table"?
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

I forgot to mention this. I have a field called ReferenceNo3 in the query
that returns the result ReferenceNo3: ([test update test fruit
inventory].[DateProcessed]) & IIf([test update test fruit
inventory].[DateProcessed] Is Null, [test update test fruit
inventory].[DateProcessed],(","+[TableLetter]))
and I have a blank field ReferenceNo3 in test fruit inventory table that I
would like to be updated by the return value of ReferenceNo3 in the query.
Is this possible? I got the update to work with the all the information
except the ReferenceNo3 field.

KARL DEWEY said:
Try this ---
UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].DateProcessed = [test update
test fruit inventory].[DateProcessed], [test fruit inventory].TableLetter =
[test update test fruit inventory].[TableLetter]
WHERE [test fruit inventory].DateProcessed Is Null;

--
KARL DEWEY
Build a little - Test a little


Patrick said:
UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].[lot-bin#] = [test update
test fruit inventory].[lot-bin#], [test fruit inventory].DateProcessed =
[test update test fruit inventory].[DateProcessed], [test fruit
inventory].TableLetter = [test update test fruit inventory].[TableLetter];


KARL DEWEY said:
Post the complete query SQL.
--
KARL DEWEY
Build a little - Test a little


:

If I have a table, tableA, that has the same fields in it can I run an update
query to update the blank referenceno3 field in tableA. For instance the sql
returns 8/12/07,A in the update table and I want that to be put into the
tableA referenceno3 field.

:

ReferenceNo3: ([Update Table].[DateProcessed]) & IIf([Update
Table].[DateProcessed] Is Null, [Update
Table].[DateProcessed],(","+[TableLetter]))

--
KARL DEWEY
Build a little - Test a little


:

I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.

Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is
Null,[DateProcessed],(","+[TableLetter]))

How do I have the [DateProcessed] be selected from the table "Update Table"?
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

Do not use an alias that is the same as an existing field name.
--
KARL DEWEY
Build a little - Test a little


Patrick said:
I forgot to mention this. I have a field called ReferenceNo3 in the query
that returns the result ReferenceNo3: ([test update test fruit
inventory].[DateProcessed]) & IIf([test update test fruit
inventory].[DateProcessed] Is Null, [test update test fruit
inventory].[DateProcessed],(","+[TableLetter]))
and I have a blank field ReferenceNo3 in test fruit inventory table that I
would like to be updated by the return value of ReferenceNo3 in the query.
Is this possible? I got the update to work with the all the information
except the ReferenceNo3 field.

KARL DEWEY said:
Try this ---
UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].DateProcessed = [test update
test fruit inventory].[DateProcessed], [test fruit inventory].TableLetter =
[test update test fruit inventory].[TableLetter]
WHERE [test fruit inventory].DateProcessed Is Null;

--
KARL DEWEY
Build a little - Test a little


Patrick said:
UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].[lot-bin#] = [test update
test fruit inventory].[lot-bin#], [test fruit inventory].DateProcessed =
[test update test fruit inventory].[DateProcessed], [test fruit
inventory].TableLetter = [test update test fruit inventory].[TableLetter];


:

Post the complete query SQL.
--
KARL DEWEY
Build a little - Test a little


:

If I have a table, tableA, that has the same fields in it can I run an update
query to update the blank referenceno3 field in tableA. For instance the sql
returns 8/12/07,A in the update table and I want that to be put into the
tableA referenceno3 field.

:

ReferenceNo3: ([Update Table].[DateProcessed]) & IIf([Update
Table].[DateProcessed] Is Null, [Update
Table].[DateProcessed],(","+[TableLetter]))

--
KARL DEWEY
Build a little - Test a little


:

I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.

Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is
Null,[DateProcessed],(","+[TableLetter]))

How do I have the [DateProcessed] be selected from the table "Update Table"?
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

There is nothing in the ReferenceNo3 field in the test fruit inventory table
so if I delete that field from the table and leave it in the query will it
create that field in the table?

KARL DEWEY said:
Do not use an alias that is the same as an existing field name.
--
KARL DEWEY
Build a little - Test a little


Patrick said:
I forgot to mention this. I have a field called ReferenceNo3 in the query
that returns the result ReferenceNo3: ([test update test fruit
inventory].[DateProcessed]) & IIf([test update test fruit
inventory].[DateProcessed] Is Null, [test update test fruit
inventory].[DateProcessed],(","+[TableLetter]))
and I have a blank field ReferenceNo3 in test fruit inventory table that I
would like to be updated by the return value of ReferenceNo3 in the query.
Is this possible? I got the update to work with the all the information
except the ReferenceNo3 field.

KARL DEWEY said:
Try this ---
UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].DateProcessed = [test update
test fruit inventory].[DateProcessed], [test fruit inventory].TableLetter =
[test update test fruit inventory].[TableLetter]
WHERE [test fruit inventory].DateProcessed Is Null;

--
KARL DEWEY
Build a little - Test a little


:

UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].[lot-bin#] = [test update
test fruit inventory].[lot-bin#], [test fruit inventory].DateProcessed =
[test update test fruit inventory].[DateProcessed], [test fruit
inventory].TableLetter = [test update test fruit inventory].[TableLetter];


:

Post the complete query SQL.
--
KARL DEWEY
Build a little - Test a little


:

If I have a table, tableA, that has the same fields in it can I run an update
query to update the blank referenceno3 field in tableA. For instance the sql
returns 8/12/07,A in the update table and I want that to be put into the
tableA referenceno3 field.

:

ReferenceNo3: ([Update Table].[DateProcessed]) & IIf([Update
Table].[DateProcessed] Is Null, [Update
Table].[DateProcessed],(","+[TableLetter]))

--
KARL DEWEY
Build a little - Test a little


:

I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.

Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is
Null,[DateProcessed],(","+[TableLetter]))

How do I have the [DateProcessed] be selected from the table "Update Table"?
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

I do not think it will.
--
KARL DEWEY
Build a little - Test a little


Patrick said:
There is nothing in the ReferenceNo3 field in the test fruit inventory table
so if I delete that field from the table and leave it in the query will it
create that field in the table?

KARL DEWEY said:
Do not use an alias that is the same as an existing field name.
--
KARL DEWEY
Build a little - Test a little


Patrick said:
I forgot to mention this. I have a field called ReferenceNo3 in the query
that returns the result ReferenceNo3: ([test update test fruit
inventory].[DateProcessed]) & IIf([test update test fruit
inventory].[DateProcessed] Is Null, [test update test fruit
inventory].[DateProcessed],(","+[TableLetter]))
and I have a blank field ReferenceNo3 in test fruit inventory table that I
would like to be updated by the return value of ReferenceNo3 in the query.
Is this possible? I got the update to work with the all the information
except the ReferenceNo3 field.

:

Try this ---
UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].DateProcessed = [test update
test fruit inventory].[DateProcessed], [test fruit inventory].TableLetter =
[test update test fruit inventory].[TableLetter]
WHERE [test fruit inventory].DateProcessed Is Null;

--
KARL DEWEY
Build a little - Test a little


:

UPDATE [test update test fruit inventory] INNER JOIN [test fruit inventory]
ON [test update test fruit inventory].[Lot-bin#] = [test fruit
inventory].[lot-bin#] SET [test fruit inventory].[lot-bin#] = [test update
test fruit inventory].[lot-bin#], [test fruit inventory].DateProcessed =
[test update test fruit inventory].[DateProcessed], [test fruit
inventory].TableLetter = [test update test fruit inventory].[TableLetter];


:

Post the complete query SQL.
--
KARL DEWEY
Build a little - Test a little


:

If I have a table, tableA, that has the same fields in it can I run an update
query to update the blank referenceno3 field in tableA. For instance the sql
returns 8/12/07,A in the update table and I want that to be put into the
tableA referenceno3 field.

:

ReferenceNo3: ([Update Table].[DateProcessed]) & IIf([Update
Table].[DateProcessed] Is Null, [Update
Table].[DateProcessed],(","+[TableLetter]))

--
KARL DEWEY
Build a little - Test a little


:

I receive an error of specified field [DateProcessed] could refer to more
than one table listed in the from clause of your sql statement.

Here is my statement:
ReferenceNo3: ([DateProcessed]) & IIf([DateProcessed] Is
Null,[DateProcessed],(","+[TableLetter]))

How do I have the [DateProcessed] be selected from the table "Update Table"?
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: Specified field refers to more than one table 6
query 2
Error: Specified field could refer to more than one table 8
Referring to fields in a subquery 1
specified field could refer to more than one table 6
Error message in report 1
Query gives me a warning when I ru it... 1
create calendar event using external data 1

Top