If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Appending to same table
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 |
#2
|
|||
|
|||
Appending to same table
Could you share your table structure or are you asking for table design advice?
-- Duane Hookom Microsoft Access MVP "SquirrelToothAnnie" wrote: 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 |
#3
|
|||
|
|||
Appending to same table
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 "Duane Hookom" wrote: Could you share your table structure or are you asking for table design advice? -- Duane Hookom Microsoft Access MVP "SquirrelToothAnnie" wrote: 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 |
#4
|
|||
|
|||
Appending to same table
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. -- Duane Hookom Microsoft Access MVP "SquirrelToothAnnie" wrote: 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 "Duane Hookom" wrote: Could you share your table structure or are you asking for table design advice? -- Duane Hookom Microsoft Access MVP "SquirrelToothAnnie" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|