Member Panel

Just have a member field as you did before, and instead of using yes/no, user the members names instead?

Hi!

I'm trying this right now. I've only got one field (for those who attending events; ther are lots of other fields, as listed before) and I've called it 'member'. Under queries, I have added 'Member' as a field, 'Events' as the table (same as the rest), checked 'show', and entered [club].[member] under criteria. Then when I run the query I get asked to enter parameter value. It nearly works! If I enter 'Louise' as parameter, I get results for events in which Louise and only Louise is attending. If, in the original table, I've entered 'Louise, Lynda' as members who are attending, I get no result from the query unless I enter 'Louise, Lynda' (exactly) as the parameter value.

ahhh, indeed it will require the exact contents of the row that your selecting, I didn't realise you would be using it that way. Best practice is to use the minimal amount of fields as possible, but this is only really necessary if the DB may end up holding large amounts of data. My idea was that you would keep a single name in the member field. If two or more members are doing the same event, copy and paste the details of that event into the next row and change the name of the member.

This may or may not work for you, I'm still not completely clear on how you work this database on a day to day basis, so if you were happy using it the way you were originally, then there's no need to listen to me lol. This exact same method will still work if you had a field name for each member, and then entering a yes for each member that you want to include within the query.

If your unsure, you could always zip up the database and attach it here, it wouldn't take 5 minutes?

Only if there is no sensitive data in it though please

Ok: database is attached. There's no sensitive data on it as the info is just made up right now. I was just creating a frame for the actual database, which I was hoping to put together next week in the office. As you'll see, there are check boxes under some field names. The names of these fields are those of the staff. The 'member' field is as we have discussed online, and which only works when there's no more than one person named in it! I guess I could make check boxes for every club member, but does that mean I would have to modify my query and report each time I ran it? Redesigning the report each time I want info for a new member is something I want to avoid because it takes a while. Also, I don't fancy the idea of replicating each trip in a new row.

I assumed that a table like the one I want would be a pretty straightforward Access task. Perhaps it is but my limited knowledge has made it more complicated than it should be.

Thanks for offering to look at it; I'm looking forward to see what you say.

Regards,

Colin

Nice, I can see where you were going there. There's a mixture of both solutions in there. Now if you need to add a member to an event, you'll have a dropdown box with a list of names. More names can be added in the "Members" table if you have more/less members at a later date. You'll see how close you were to the query and report when you see it. Here you go.

Magic! Thanks a lot! I see that I was close: the multiple Member searches on the query was not considered by me, but the drop-downs were: I just didn't know how to create drop-downs. I'll backwardly-engineer (is that the phrase?) your design to work out how it's all done.

But...there is one thing. The report is set-up to display Member1's name at the top, regardless of who the report is for. Is it possible to replace that with the specified parameter?

Regards,

Colin