If you post a sample of the type of data you have to work with - DON'T use
real data - then I'm sure that someone will be able to help you out.

It doesn't sound too complex.

Can I suggest that you make astart yourself.
1 Create a table (call it tblPeronnel).
in this table create
An Autonumber field - make this the primary field.
Also add the following
1stname
Surname
1s tline of the address
2nd line of the address
3rd line of the address
4th line of the address
ZipCode or PostCode
Salutation (thats Mrs, Mrs, Miss,Dr, etc,etc)
You can add any other details you want "as long as this information only
applies to the specific person"
All of these fields are text fields - except for the Autonumber field.
Don't add - speaker, guest, etc to this table

Next create another table with details of the meetings you hold
Autnumber - primary
Date of meeting (date . time format)
Location of meeting
Plus other items eg. Max seating, etc

Now the 3rd table I would suggest that you hold off with. Just create the 2
above and then come back to this form ans someone will be able to tell you
how to link them together with a many to many (thats many people can go to
many meetings and many meetings can have many people in them).
In this 3rd table is where you will store the details of speakers, guests,
etc - as they are applicable to a specific mix of people and meeting.

Post back when you have the 1st 2 tables done.



Next

--
Wayne
Manchester, England.



"shumate62" wrote:

I'm throwing myself at the mercy of the experts and asking for help. I
volunteered to help my local library- fundraiser group create a database in
order to put their annual event names in a computer rather than the stack of
loose papers and notes they have in a three inch file. Each year they have to
spend days handwriting invites and sorting through the names etc and I wanted
to put it in a specific type of database. I thought I would be able to create
it but after spending every spare minute I had over the last month or two
watching tutorials and making a thousand broken databases I have reached the
conclusion that I am a failure at Access.
The database I wanted to create seems so simple I know it would take an
Access master a mere 27 and a half minutes to create it. The basic idea is
an address book table with Name, Address, Email, etc. Then a second table
that lists the type of person they are Speaker, Guest, Media, and then a
third table allows for the year to be selected for that type (In 2007 John
Smith was a Speaker and then in 2008 he was a Guest, etc) so you would have
the address book part and then a subform below that would allow for two combo
boxes with the type of person and the year.
Does anyone already have something like this created that I could just enter
in my data? Anything like that?
Thank you thank you thank you so much for any help!!!!