UPDATE statement - at wits end - Please help!

[Louise]

I have generated an UPDATE statement but keep getting the error message that it was expecting a reserved word.

Naturally the statement begins with UPDATE so I can't figure out where the problem is.

could someone please take a look and help?

UPDATE tblComparativeVolume RIGHT JOIN tblVolumeData ON tblComparativeVolume.Id = tblVolumeData.Id
SET tblComparativeVolume.[Date] = [tblVolumeData].[Date], tblComparativeVolume.Client = [tblVolumeData].[Client],
tblComparativeVolume.Activity = [tblVolumeData].[Activity], tblComparativeVolume.Product = [tblVolumeData].[Product],
tblComparativeVolume.ActivityDesc = [tblVolumeData].[ActivityDesc],
tblComparativeVolume.Period2 = [tblVolumeData].[TotalVolume]
WHERE [tblVolumeData].[Date] BETWEEN #4/1/2000# AND #6/30/2000#


this works in an ordinary query so why not in a querydef?

ps - I know that all field names should be enclosed in square brackets and they are in the querydef.

 

[Jman]

Wow that's really interesting I am also at a lack for a solution but if I were you I would troubleshoot this problem by recreating your query in the "front end" query builder in access. Then you could view the query in sql and use this for research
Please let me know what happens and how you solve this my adress is jkc3computerhack@yahoo.com
good luck John

 

[yeatmanj]

I don't know that this will be any help, but I have run across cases where the table names had to be either in brackets or in quotes. You may give that a try. Good luck and please post a solution here if you find it.

 

[chrismcbride]

Louise
It is also possible that you should be using the keyword HAVING rather that WHERE. This is just a guess, mind you.
Chris