Problem with join 1

[verstapp]

2 tables:
assets: ... [asset id] ...
pvtorecycle: fred

Both fields are text.

Prior to updating certain records in assets i first try to find them using values previously typed into pvtorecycle.fred.

SELECT *
FROM assets
WHERE pvtorecycle.fred = assets.[asset id];

However, when I run the query I get a 'enter parameter value', 'pvtorecycle.fred' dialogue.

Spot the obvious error.

 

[dhookom]

Your FROM clause doesn't include the table pvtorecycle table.

Duane
Hook'D on Access
MS Access MVP

 

[verstapp]

Oops, how embarrassment!
My problem is that I do this sort of thing so rarely that I forget a lot between times.
Works now, thanks heaps.

 

[MazeWorX]

Works now, thanks heaps

then thank him with a a star

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>