On Thu, 13 May 2010 11:19:01 -0700, 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!!!!

I have a copy of your current Word doc describing your needs and will try to
get back to you in the next day or so (free of charge).

--

John W. Vinson [MVP]