Run my query it prompt which i dont want

[Eric]

When I run my query it prompt to enter ti.Tech is it possble without
asking, it match the ti.tech and corp with FS_TechID and AccountNum.

Thanks.

SELECT ti.CORP, ti.TECH, ti.TECHCONT, ti.tech_id AS Expr1,
tpr1.AccountNum
FROM [select tpr.*, Mid(tpr.AccountNum,1,5) as tprCORP from
tbl_PPVResearch as tpr]. AS tpr1 INNER JOIN tech_id AS ti ON
tpr1.tprCORP = ti.CORP
WHERE (((ti.TECH)=[tpr1].[FS_TechID1] Or (ti.TECH)=[tpr1].[FS_TechID2]
Or (ti.TECH)=[tpr1].[FS_TechID3]));

 

[Douglas J. Steele]

Are you sure you've typed the names of the fields correctly?

 

[Eric]

Thanks for your time, it was my typing mistake.

Are you sure you've typed the names of the fields correctly?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

When I run my query it prompt to enter ti.Tech is it possble without
asking, it match the ti.tech and corp with FS_TechID and AccountNum.

Thanks.

SELECT ti.CORP, ti.TECH, ti.TECHCONT, ti.tech_id AS Expr1,
tpr1.AccountNum
FROM [select tpr.*, Mid(tpr.AccountNum,1,5) as tprCORP from
tbl_PPVResearch as tpr]. AS tpr1 INNER JOIN tech_id AS ti ON
tpr1.tprCORP = ti.CORP
WHERE (((ti.TECH)=[tpr1].[FS_TechID1] Or (ti.TECH)=[tpr1].[FS_TechID2]
Or (ti.TECH)=[tpr1].[FS_TechID3]));