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

Need some help please

P: n/a
There are four tables in my database, three are connected with the
TicketNum(Tbl_PPVResearch,Tbl_ValidDispute,tbl_Eve nts). 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
-------
ID PK
CORP Type Text 00000
Tech Type Text 00000
TECHCONT Type Text

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


P: n/a
Normalize your tables, then use the OnNoData event of the report. It
won't open if it has no data.
Why do you have Tech(1,2,3) and the like? These should be child
tables. How do you create joins if you have account and tech numbers in
three different fields? You're making it really hard to design your
database so it works for you if you do this. Yes, you _can_ union all
this junk together, but why? Why not just build it right to begin
with?

You might want to read Database Design For Mere Mortals by Michael
Hernandez, or the discussion on Normalization by Roger Jennings in his
Que book on Access. It's in the first 100 or so pages, I think. (It's
been a _long_ time, but his explanation of how to normalize is
_excellent_).

Sep 5 '06 #2

P: n/a
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
"Eric" <eh******@gmail.comschreef in bericht news:11*********************@74g2000cwt.googlegrou ps.com...
There are four tables in my database, three are connected with the
TicketNum(Tbl_PPVResearch,Tbl_ValidDispute,tbl_Eve nts). 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
-------
ID PK
CORP Type Text 00000
Tech Type Text 00000
TECHCONT Type Text
Sep 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.