E
Eric
If i remove the
"LastValidTech.Account1=[Forms]![frmDHG]![Cbo_AccountNum]" query shows
the values but if i put an input and then pass value thru it then it
not shows any thing. I dont know what is a problem their.
SELECT tbl_PPVResearch.TicketNum, LastValidTech.Account1,
tbl_Events.txt, tbl_Events.PPVVOD_Amt, LastValidTech.Account2,
LastValidTech.Account3, LastValidTech.Account4,
LastValidTech.LstVldTech, tech_id.TECHCONT
FROM ((LastValidTech INNER JOIN tbl_PPVResearch ON
LastValidTech.TicketNum = tbl_PPVResearch.TicketNum) INNER JOIN
tbl_Events ON tbl_PPVResearch.TicketNum = tbl_Events.TicketNum) INNER
JOIN tech_id ON LastValidTech.LstVldTech = tech_id.TECH
WHERE (((LastValidTech.Account1)=[Forms]![frmDHG]![Cbo_AccountNum]) AND
((Val(Left([LastValidTech].[Account1],5)))=[tech_id.corp]));
Data with input no values
[Forms]![frmDHG]![Cbo_AccountNum]
07836-047003-01
DATA WITHOUT INPUT
-----------------
TicketNum,Account1,txt,PPVVOD_Amt,Account2,Account3,Account4,LstVldTech,TECHCONT
004275,"07836-047003-01",IJKLMNOP,$0.00,00000-00000-00,078651234514,00000-00000-00,123,Fox
004275, "07836-047003-01",ABCDEFGH,$0.00,00000-00000-00,078651234514,00000-00000-00,123,Fox
Thanks.
"LastValidTech.Account1=[Forms]![frmDHG]![Cbo_AccountNum]" query shows
the values but if i put an input and then pass value thru it then it
not shows any thing. I dont know what is a problem their.
SELECT tbl_PPVResearch.TicketNum, LastValidTech.Account1,
tbl_Events.txt, tbl_Events.PPVVOD_Amt, LastValidTech.Account2,
LastValidTech.Account3, LastValidTech.Account4,
LastValidTech.LstVldTech, tech_id.TECHCONT
FROM ((LastValidTech INNER JOIN tbl_PPVResearch ON
LastValidTech.TicketNum = tbl_PPVResearch.TicketNum) INNER JOIN
tbl_Events ON tbl_PPVResearch.TicketNum = tbl_Events.TicketNum) INNER
JOIN tech_id ON LastValidTech.LstVldTech = tech_id.TECH
WHERE (((LastValidTech.Account1)=[Forms]![frmDHG]![Cbo_AccountNum]) AND
((Val(Left([LastValidTech].[Account1],5)))=[tech_id.corp]));
Data with input no values
[Forms]![frmDHG]![Cbo_AccountNum]
07836-047003-01
DATA WITHOUT INPUT
-----------------
TicketNum,Account1,txt,PPVVOD_Amt,Account2,Account3,Account4,LstVldTech,TECHCONT
004275,"07836-047003-01",IJKLMNOP,$0.00,00000-00000-00,078651234514,00000-00000-00,123,Fox
004275, "07836-047003-01",ABCDEFGH,$0.00,00000-00000-00,078651234514,00000-00000-00,123,Fox
Thanks.