Select which record to draw data from.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Say there are 5 events in the list. I want it to pop-up a message box
prompting for the eventID, so it knows which record to show.

I can do it in Query Design but thats not flexible enough I want it to ask
for the ID when the REPORT is run.

From there i can have the event info shown as a subreport on the main report
that holds all the peoples info.

Hope im making sense.


Jeff Boyce said:
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

Widemonk said:
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
Click to expand...
Click to expand...
 
Consider another approach...

You can create a form from which you "request" your report. On the form,
add a combo box that lets you select which event. Add a command button that
opens the report. In the report's underlying query, "point" to the form's
combobox selection as a selection criterion (looks something like:)
Forms!YourOrderForm!YourComboBox

Regards

Jeff Boyce
Microsoft Office/Access MVP

Widemonk said:
Say there are 5 events in the list. I want it to pop-up a message box
prompting for the eventID, so it knows which record to show.

I can do it in Query Design but thats not flexible enough I want it to ask
for the ID when the REPORT is run.

From there i can have the event info shown as a subreport on the main
report
that holds all the peoples info.

Hope im making sense.


Jeff Boyce said:
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

Widemonk said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top