to all the GURU's - Multiple fields in a report!

[trackmedic]

Hello GURU's,

I have a report that displays information on visitors to a work site. The report sorts by the "visitor" field of a query. My boss now wants me to add 3 more visitor fields.

How would I (in a query or report) allow the "visitor", "Visitor_1"... fields to work on my report.

Basically, if John Doe was visitor 1 on week one and visitor 3 on week 2, I would like the report to combine these two fields to show John Doe as having two documented visits.

confused, but thanks in advance!

 

[wiklendt]

first of all, you would need to make sure your data is normalised. so you would have a table for visitors, and a table for visits. (because one visitor can visit many times, you need that one-to-many table structure/relationship). once you have this working, then you can put in a sub-report into your report linking by VisitorID. the subreport will list all the visits for each visitor.