Select which record to draw data from.

[Widemonk]

I have a report that prints a list of details of various people who are
attenting an event.
The very first page of this report I want the event details... venue,
contact name, number of days etc.

These details are stored in a separate table, in a list of previous events,
but how do i get my report to show event details for the event with [x]
autonumber.

Thanks very much

 

[Jeff Boyce]

We're not there. We can't see your data. I have no idea what "[x]
autonumber" refers to.

If you are saying you want a report that has the event information at the
top, and detail information for the folks attending, you can use a main
report/subreport construction. The main report refers to the event
information. The subreport refers to the person information. The
subreport, embedded in the main report, uses the EventID to keep the two in
synch.

Regards

Jeff Boyce
Microsoft Office/Access MVP