Report Query

[Eric]

There are four bind drop down variables in my form. One
LastvalidTechni cian is not bind with any table. The two tables are
connected by ticketnum. When user select AccountMain and enter
LastvalidTechni cian. It goes to tableC and match with first 4 digit of
AccountMain if match then goes to tech of tableC and match with
LastvalidTechni cian once both match it print the report.Same when user
select OtherAccnt1 it match with the first 4 digit of Corp and then
match the LastvalidTechni cian with tech and print the report. Same with
otherAccnt2 and otherAccnt3. Can any one please help me how to i write
a query and then how to pass it into report.


TicketNum of tableA
AccountMain of tableA

TicketNum of tableB
OtherAccnt1 of tableB
OtherAccnt2 of tableB
OtherAccnt3 of tableB
LastvalidTechni cian of tableB

Corp of tableC=first 4 digit of all 4 accounts
Tech of tableC
techcont of tableC

REPORT
TicketNum,Accou ntMain, OtherAccnt1, OtherAccnt2, OtherAccnt3,
LastvalidTechni cian,Techcont


Thanks.

[pietlinden@hotmail.com]

Re: Report Query

Create a new query. drop in the tables that you need to connect all
the dots. Drop in the fields you want to see in your report. Join the
tables Primary Key to Foreign Key (or however you need to to get the
info you need). Base the report on your query. I'd run the query
first to make sure it has all the data you want.

pass all the filters in the Open event of your report. See the help
under OpenReport. The wizard will do this stuff too. Make friends
with the help. It's sometimes actually helpful.