Need some help please

[Eric]

There are four tables in my database, three are connected with the
TicketNum(Tbl_PPVResearch,Tbl_ValidDispute,tbl_Events). I create a
parameter form where user select the accountnumber. There are four
account in my parameterform(one from
Tbl_PPVResearch,3 from Tbl_ValidDispute). I need help here user select
one or more then one account and also type the technician ID. Once
account numbers are selected and technician ID is typed it press the
search button and the query has to go to Tech_ID table and match the
first five digit of account numbers with corp and also the Tech_ID.tech
once both match it print the report

REPORT
------
txt,AccountNum,OtherAcct1,OtherAcct2,OtherAcct3



Tbl_PPVResearch
---------------
TicketNum Autonumber PK
AccountNum Type Text 00000-000000-00
FS_TechID1 Type Text 00000
FS_TechID2 Type Text 00000
FS_TechID3 Type Text 00000

Tbl_ValidDispute
-----------------
TicketNum Number
LstVldTech Type Text 00000
OtherAcct1 Type Text 00000-000000-00
OtherAcct2 Type Text 00000-000000-00
OtherAcct3 Type Text 00000-000000-00

tbl_Events
----------
TicketNum Number
txt type Text


Tech_ID

 

[Arno R]

Eric,
Why are you STILL not listening ??
Please do NOT multipost !!!!

If you *have to* then crosspost.
Multi-posting really is wasting people's time.

Arno R