Event Management Database Template

[Guest]

I am working with the Event Management Database Template. So far, it works
perfectly for what I want to do except for a few things...

I have multiple events that I enter registrations for and I want to get an
attendee listing for only the attendees who are registered for a specific
event. Right now, it gives me all attendeess for all events.

I am not technically advanced, so please answer with very specific
directions on what to do. I have tried creating a report and a query, but I
am not getting the results I want.

Thank you!!!

 

[Guest]

Hi Amy,

You need to have your query behind your report so that it limits the data to
a single event. Let's say you have a field called EventID. In the criteria
section of your query, put [Enter the Event ID], then when your query runs it
will prompt you for the Event ID, which you can type in.

A better way to do it would be to pick the EventID up off a form... have
forms!FORMNAME.lngEventID as the criteria, where FORMNAME is the name of the
form and lngEventID the name of the field containing the EventID you want.

Hope this helps.

Damian.

 

[Jeff Boyce]

Another approach to that offered by Damian (restrict the query that feeds
the report) would be to use a query that returns all records (in case you
want a report with all records), but use a form to collect an ID and a WHERE
clause or filter to limit the records the report actually prints. Check
Access HELP for the
DoCmd.OpenReport
syntax to see where/how you'd use this.

Regards

Jeff Boyce
Microsoft Office/Access MVP