Re: Query Syntax error for Concatenate

From: Ken Snell (kthissnellis9_at_notcomcast.realnet)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 09:22:35 -0500

You don't have a table named stito in the SQL statement; instead, you have a
table named To. One or the other has to change to match the one that you
don't change, for example:

UPDATE [stito] INNER JOIN [stifrom]
ON [stito].[CaseID] = [stifrom].[CaseID]
SET stito.Journal = [stito].[Journals]+": " & [stifrom].
[Journals]
WHERE (((stifrom.Journals) Is Not Null)); 

-- 
       Ken Snell
<MS  ACCESS MVP>
"DBarker" <DBarker@discussions.microsoft.com> wrote in message
news:1692801c41729$f73a5630$a101280a@phx.gbl...
> I tried this on test data and it worked, but when I try
> to edit it for my current database I get a join error and
> it points to the "ON [stito]" section, I have tried
> taking brackets away and leaving them in.  I have tried
> everything.  I don't know why this is not working any
> help would be appreciated.
>
>
>
> UPDATE To INNER JOIN [stifrom]
> ON [stito].[CaseID] = [stifrom].[CaseID]
> SET stito.Journal = [stito].[Journals]+": " & [stifrom].
> [Journals]
> WHERE (((stifrom.Journals) Is Not Null));
>
>