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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating A Report From Normalized Tables in Access 2000

Status
Not open for further replies.
wrksmrt

wrksmrt

Technical User
May 7, 2003
2
US
I have two tables (using Access 2000): tblRecruit, tblVisitors. Linked one-many by field RecruitID. A recruit can have no visitors up to three visitors. (At least right now they can only have three - that may change in the future.) That part is no problem. My problem is trying to create a report based on these two tables with the recruit and his visitors appearing on one line. I grouped on recruit and hid duplicates but I cannot get the visitors to appear next to the recruit on the same line. The report needs to be in this format:

Recruit Name Visitor1 Name Visitor2 Name Visitor3 Name

Make sense? Any help anybody can give me with this would be greatly appreciated.

Thanks,
Jon
 
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Office 2000 XL
Replies
6
Views
525
dhookom
dhookom
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
459
combo
combo
E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
345
SkipVought
S
titanif
  • Locked
  • Question
Office 365- Spill A Table Column Into Another Tables Column
Replies
1
Views
133
SkipVought
S
lm1340
  • Question
Upload documents to Jira Cloud from SharePoint using Power Automate
Replies
0
Views
53
lm1340
lm1340

Part and Inventory Search

Sponsor

Back
Top