Recent content by dah

Hi, I looked over the examples you sent but it still does not answer my question. I can do the mail merge fine except that I only get one row of information per person. I tried creating the report and then copied the info into Excel. Again, if one person attended more than 1 workshop I get...

Hi, I have created a database that seems to work ok now. Been a real learning experience. I now need to take information from the database and do a mail merge into Word. I have done mail merges with Excel before but not Access. I have a form designed that shows participant information and...

I looked at the picture of the two subforms. I could not download the sample many to many database. Just tells me the database is not recognized. Anyway, I made another table (Presenters), used the already made table (Workshops) and made a LinkWorkshopToPresenter table which has the primary...

I guess the problem will help. My database has Participant Table (ID Primary key) Workshops Table (ID primary key) Link Workshop to Participants (Two ID key fields) A form with participant information on top and a subform with all the workshop information. The two individual tables have a...

Hi, I have a database set up that uses a participants table and a workshop table. Each have primary keys. A third table is set up and has the two primary keys from the participant and workshop table. This was working fine. I now need another table (Presenters) to account for people who...

Hi, I developed a form, based on a table, which is working fine until now. Recently some names were entered into the form. Since their ID number is an autonumber, these new entries went at the bottom. This didn't seem like a problem but for some reason the names will not sort alphabetically...

Maybe it makes a difference if I am looking of workshop numbers between those dates. For example: Workshops 1 to 18 are Year 1 = 8/1/2001 to 5/1/2002 Workshops 19 to 65 are Year 2 = 8/1/2002 to 5/1/2003 So I want total individuals who attended any workshops (1 to 65) from 10/1/2001 to...

I guess I am not understanding what a query will do for me. Year 1 = 8/01 to 5/02 Year 2 = 8/02 to 5/03 Overall of year 1 and 2 = 8/01 to 5/03 There is no data for 5/02 to 8/02 (no workshops, dates or individuals). So, if Year 1 saw 10 individual people attend workshops and Year 2 saw 7...

Hi, I thought of that too but there are no workshops between 5/02 and 8/02.

Hi, I have developed a database that gives me information on the number of people attending college workshops and the number of workshops each person has attended. I want a total of individual people who attended workshops and then the total of people who attended multiple workshops. I ran...

Hi, I have created a form which shows all members of an institute and a subform which lists all the workshops they have attended. The form works fine. I have a combo box set up to enter a number and this brings up all the participants information including the workshop subform info. My...

Hi, I am still having a bit of trouble getting my database information to come up automatically in the form I created. I want to just type in an ID number and have all data come up associated for that particular person. Also, I would like to be able to add a new record (for someone who is...

Hi, I am trying to develop a query so that information from my table automatically comes up in a form with a subform. I have three tables: Participants Workshops and LinkWorkshops To Participants (has long int and two PK - one for ParticipantID and one for WorkshopID. Any thoughts on how...

I have set up a database with participants and workshops. I need a form which will bring up all the participants info automatically along with a subform that lists all the workshops they have attended. I want to be able to type in the participants ID number, all their info comes up and then...

The database is set up nicely now. Thanks. I was very close but my third table was not set with two PK and numbers. Now the participants table has a subdatasheet that shows all the workshops a participant attended and the workshop table does the same. Thanks again.