A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Appending to same table



 
 
Thread Tools Display Modes
  #1  
Old November 26th, 2006, 11:34 PM posted to microsoft.public.access.queries
SquirrelToothAnnie
external usenet poster
 
Posts: 10
Default 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  
Old November 27th, 2006, 12:04 AM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old November 27th, 2006, 10:29 AM posted to microsoft.public.access.queries
SquirrelToothAnnie
external usenet poster
 
Posts: 10
Default 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  
Old November 27th, 2006, 04:17 PM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.