creating a report

D

Dale Laurich

Hi,
I would think this should be a simple task but I can't seem to figure
it out. I have three tables "tblPR_Name" , "tblList" and
"tblPR_Groups".
tblPR_Name contains 2 fields "P_Name" and "P_Phone"
tlbPR_Groups contains "P_Name" and "Dept"
tblList contains a Date field and P_Name field for each
department
ie. 15 fields that tell me the name of the person
representing that department for today

My form has the names of each dept on it and I just select the person
assigned for that day in each dept.

My problem is with the generation of a report. I can easily create a
report with the names on it but I also need the phone numbers to print
in a field next to the persons name on the report. My report is to be
generated from tblList but I also need the phone numbers from the
joined table tblPR_Name. Any suggestions would be appreciated.
Thanks,
Dale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weekly Report 2
Grouping Names in Mail Merge 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report Group Footer DLookUp 0
Mail Merge Directory Conditional Page Break 0
Creating a Search using a combo box and then creating a report. 4
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
vlookup retunrning a match, when not a match... 11

Top