Runtime error 3061 - Too few parameters. Expected 2. ---- WHY????

[scott0_1]

Hello,



I'm running the following query, which I used the query builder to help with:

UPDATE tblPositionNumbers SET tblPositionNumbers.CostCentre = [tblImportTMP].[F3] WHERE [tblPositionNumbers].[PositionNumber]=[tblImportTMP].[F2];

This should be the easiest query to run ever, but I'm getting an error say that it is expecting two parameters.

The preceding code grabs data from an Excel sheet and puts it into a table in Access. I've checked the table; there is data. The data in the columns is correct.

I use very similar code to insert new lines into the tblPositionNumbers table and it works fine.

Can anyone see what I'm missing here?

[Micron]

Without seeing the underlying data sources it's impossible to pinpoint the problem exactly. I can tell you that the message means that 2 parameters cannot be resolved. What we can't say for sure is why. Often, it's a spelling problem but sometimes it's a reference problem; i.e. the path to the source fields can't be resolved. This could be any of a myriad of reasons, such that the source isn't open (when it's a form, for example). Suggest you copy this sql to a new query in sql view then switch to datasheet view (so that the query won't actually run but will process the sql) and see what happens. I'd expect the sql view to highlight the offending part (but one at a time). You could also just view this in design view and see if it makes sense. Perhaps your source reference doesn't appear in the design, but should.
EDIT
The table that holds this ([tblImportTMP].[F3]) and the other reference should be there.

[isladogs]

The message is telling you there are 2 items it cannot resolve

1. For this to work you need to explicitly include both tables

UPDATE tblPositionNumbers INNER JOIN tblImportTMP ON [tblPositionNumbers].[PositionNumber]=[tblImportTMP].[F2] SET tblPositionNumbers.CostCentre = [tblImportTMP].[F3];

2. If its a SQL statement in code, you also need text or number delimiters around the F3 part depending on the datatype for F3

[scott0_1]

The message is telling you there are 2 items it cannot resolve

1. For this to work you need to explicitly include both tables

UPDATE tblPositionNumbers INNER JOIN tblImportTMP ON [tblPositionNumbers].[PositionNumber]=[tblImportTMP].[F2] SET tblPositionNumbers.CostCentre = [tblImportTMP].[F3];

2. If its a SQL statement in code, you also need text or number delimiters around the F3 part depending on the datatype for F3

Bingo on the inner join!

Thanks for the help!

[isladogs]

You're welcome.