"Enter Parameter Value" Error When Updating Sharepoint Table/List (1 Viewer)

[StephenB]

Hello everyone.
I have a list (table) that I've created in sharepoint 2010.
I link to the sharepoint table with Access 2010 to update mass amounts of items at once. Some of the queries have no problem updating the sharepoint items, but other queries require me to "Enter Paramater Value." I done some research and found that the "the dreaded 'Enter Paramater Value' " issue, but none of the solutions help me.

In this particular queries; I'm trying to populate field A with dates from field B, when field A is null.
---------------------
UPDATE Table 1 SET Table.[FieldA] = [FieldB]
WHERE (((Table 1.[FieldA]) Is Null));
--------------------
When I run the above, I receive the "Enter Parameter Value" input box.
All records have Field B populated (it's actually the created date.)

The goal is for field A to be populated with the values in Field B, without the query asking for parameters.

Note; I can go in each individual record and update them via access, one at a time. But it's the running of the update query that failing.

Thanks in advance for any thoughts or insight.

Edit: Removed spaces in table and field names.

 

[spikepl]

The thing has no idea what

table 1

is.

This is what you get when you use spaces in object names. You condemn yourself to using [] brackets around such names. Consistently, that is. Which you did not.

Here is a naming convention you could use: http://www.access-programmers.co.uk/forums/showthread.php?t=225837

 

[StephenB]

Thank you. The actual table and field names have no spaces. I'm going to correct that above.

 

[StephenB]

Bumping since I'm still having this issue. Hoping a new set of eyes will help.