E
Eric
This query works fine but i want to pass the AccountNum from a
parameterize userform where user enters AccountNum and then pass it
into query. How to i do that needs help
Form Name:Frm_AccountNum
Enter AccountNum:
SELECT ti.CORP, tbl_ValidDisputes.LstVldTech, ti.TECH, ti.TECHCONT,
tpr1.AccountNum, tbl_Events.txt
FROM tbl_ValidDisputes INNER JOIN (([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) INNER JOIN
tbl_Events ON tpr1.TicketNum = tbl_Events.TicketNum) ON
tbl_ValidDisputes.LstVldTech = ti.TECH
WHERE
(((nz([tpr1].[FS_TechID3],nz([tpr1].[FS_TechID2],[tpr1].[FS_TechID1])))=[ti].[TECH]));
Thanks,
parameterize userform where user enters AccountNum and then pass it
into query. How to i do that needs help
Form Name:Frm_AccountNum
Enter AccountNum:
SELECT ti.CORP, tbl_ValidDisputes.LstVldTech, ti.TECH, ti.TECHCONT,
tpr1.AccountNum, tbl_Events.txt
FROM tbl_ValidDisputes INNER JOIN (([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) INNER JOIN
tbl_Events ON tpr1.TicketNum = tbl_Events.TicketNum) ON
tbl_ValidDisputes.LstVldTech = ti.TECH
WHERE
(((nz([tpr1].[FS_TechID3],nz([tpr1].[FS_TechID2],[tpr1].[FS_TechID1])))=[ti].[TECH]));
Thanks,