Building A Report

[scrappy2]

hi, I have never built a report before and im trying to contruct one using design mode. For starters I want to display 2 items,

1: show a list of name of people from a table called 'tblCallTree' using a heading 'Name'

2: show a list of the projects assigned to each of the people listed from a table called 'tblProjectList' using the heading 'Project' where 'Assigned To' equals the value in 1

Do anybody have a clear way of how to do this using VBA code rather than constructing queries?

Thanks for your help.

 

[pbaldy]

I suspect the reason nobody has answered this is because you're sort of asking "how do I build a house without a hammer and saw?". A query is the normal and easiest way to pull the data together from the 2 tables. Create a query that pulls them together then use the report wizard and you're done. Can it be done without a query? Probably, but...why bother?