Bill-
What is the Record Source of your form? If you want to see only events, don't include participant info. I assume events have their own table. If not, then perhaps that's your problem.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 27, 2015, at 9:25 PM, 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I am wondering if there is a way to GROUP records on a form like I can GROUP records in a report. I have 25 events and 50 participants. I am using a continuous form so that I can see all the events and participants.
I would like to see only 25 event IDs ( 1 for each event) but now, since the event ID is on the continuous form I see the event ID 50 times, once with each participant.
Any thought?
Bill
MN
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar