specified field error

[Patrick]

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"?

 

[KARL DEWEY]

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

 

[Patrick]

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"?

 

[KARL DEWEY]

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"?

 

[Patrick]

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"?

 

[KARL DEWEY]

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"?

 

[Patrick]

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"?

 

[KARL DEWEY]

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

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"?

 

[Patrick]

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?

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

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"?

 

[KARL DEWEY]

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

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?

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

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"?