Appending to same table

[Guest]

Hi,

I have a table called "session reports" where the data is entered into it
via a form. At present I can do one member/one session report but I'd like to
be able to add several members to one session (as they can attend solo or in
a group) without re-typing it for each member. I need to be able to produce a
report for each individual member thats lists every session they attended be
it a group or individual session ( and in date of session order) and for the
user not to be able to see the background. I seem to be trying to append to
the same table if you know what I mean! I'm fairly new to Access so any help
would be greatly appreciated.
Thanks

 

[Guest]

Could you share your table structure or are you asking for table design advice?

 

[Guest]

Hi,

Not sure I understand the question as I'm fairly new to Access but..
It's just the one table I'm dealing with here. I've already deisgned it-
just a basic table. But I need to append one record from it (for one member)
to the same table (for other members). So in effect we'd have two or more
records exactly the same apart from the Member No'

Thanks

 

[Guest]

Do you have a method of selecting multiple members? This can be done with a
multi-select list box based on a SQL statement that selects each unique
member.

Once you have selection method created, come back with your form and control
name for the selection as well as your significant table and field names.