By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,010 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Report Query

P: n/a
There are four bind drop down variables in my form. One
LastvalidTechnician is not bind with any table. The two tables are
connected by ticketnum. When user select AccountMain and enter
LastvalidTechnician. It goes to tableC and match with first 4 digit of
AccountMain if match then goes to tech of tableC and match with
LastvalidTechnician 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 LastvalidTechnician 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
LastvalidTechnician of tableB

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

REPORT
TicketNum,AccountMain, OtherAccnt1, OtherAccnt2, OtherAccnt3,
LastvalidTechnician,Techcont
Thanks.

Sep 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Sep 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.