Query Problem

E

Eric

In Tbl_ValidDispute i have to search all three otheraccounts. First if
otherAcct3 is not empty and match first five digit with tech_id.CORP
and also match the LstVldTech with tech_id.TECH and if they both match
then print the report. If otherAcct3 is empty but otherAcct2 is not
empty then match first five digit with tech_id.CORP also match
LstVldTech with tech_id.TECH if both match then print the report. if
otherAcct2 and otherAcct3 is empty then match with otherAcct1 and print
the report.

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

Tech_ID
-------
ID PK
CORP Type Text 00000
Tech Type Text 00000
TECHCONT Type Text

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some help please 1
Help in query 2
Union two queries 0
Help in query 2
Data shows without input 0
Use Instr 1
Can any one please help me out 0
Format problem using combo box 1

Top