Simple 3 table join popping up a parameter box?

[d. motsiff]

hey access types --

can anyone point out why this simple query in Access 2002 pops up a
parameter box asking me for the "it.lookupcode" when i run it? ( or
point me towards a URL that could?)

---------------------------------------------------------------------------
select *
from (Transactions AS tr INNER JOIN TransactionEntry AS te ON
tr.TransactionNumber = te.TransactionNumber) INNER JOIN Item AS it ON
te.ItemID = it.ID
where it.lookupcode like 'LGN*';
---------------------------------------------------------------------------

Im thinking this should just select all the records and all fields in
my 3 table join that have an "it.lookupcode" that's well, like
"LGN*".

Why does Access want to ask me again at run time for the where
clause criteria?

Obviously my Oracle syntax skills arent gloing to transfer over to
Access too well, huh? Obviously im missing something very basic.

any help greatly appreciated,
dale

 

[Michel Walsh]

Hi,


There is probably no such field name lookupcode in table Item (typo error, probably).

Hoping it may help,
Vanderghast, Access MVP