Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
multiple phone numbers producing multiple details
I'm pulling the address from another table that will only accept one address per company...my phone table allows for numerous numbers. Strangely, when I enter the query in to a field on my report (and run the report) I am prompted for the parameter- conwayap
- Post #8
- Forum: Microsoft: Access Reports
-
multiple phone numbers producing multiple details
why wouldn't this work: SELECT DataOrgPhone.PhoneNumber FROM DataOrgPhone WHERE ((DataOrgPhone.PhonePrimary)=1);- conwayap
- Post #6
- Forum: Microsoft: Access Reports
-
multiple phone numbers producing multiple details
Remou, separate tables- conwayap
- Post #4
- Forum: Microsoft: Access Reports
-
multiple phone numbers producing multiple details
I have three phone numbers for a particular organization...and the entire detail is repeated for each unique number...how can I tweak this to just show the primary number (field PrimaryNum with value 1) and thus one entry per company? I thought this would work...- conwayap
- Thread
- Replies: 8
- Forum: Microsoft: Access Reports
