DataBase - E_lookup

E-Lookup

  John W. Vinson replied to Santosh

Do you have a question, Santosh? You're speaking to real live human
volunteers, not to a search engine...
--

John W. Vinson [MVP]

for each volunteer (representing the most recently added event). I also need to list those volunteers who have not ever worked an event (no relationship table records at all.) Thanks in pops up a dialog with 3 options. Choose the one that says: All records from Volunteers, and any matches from Query1. Technically, this is called an outer join, so you get all volunteers, whether they have worked or not. It would be possible (but probably less efficient) to allenbrowne at mvps dot org. Try something like this: SELECT FirstName, LastName, Event, EventDate FROM Volunteers, EventVolunteers AS EV1, Events WHERE EV1.VolunteerID = Volunteers.VolunteerID AND EV1.EventID = Events.EventID AND EventDate = (SELECT MAX(EventDate) FROM EventVolunteers AS EV2 Events.EventID WHERE EV2.VolunteerID = EV1.VolunteerID) UNION ALL SELECT Firstname, LastName, "None", NULL FROM Volunteers LEFT JOIN EventVolunteers ON Volunteers.VolunteerID = EventVolunteers.VolunteerID WHERE EventVolunteers.VolunteerID IS NULL; Ken Sheridan Stafford, England - - Message posted via

5 / 1 / 2010. I have an unbound form with two subforms on it [SubFrm Actual Volunteers] & [SubFrm Volunteer List]. These two subforms are linked together using a text box on the way down the page) on: www.fmsinc.com / MicrosoftAccess / Forms / Synchronize / LinkedSubforms.asp [SubFrm Actual Volunteers] : ~Master ~Has fields like [Volunteer ID] & [Event ID]. ~Also has a combo box [Name] with is actually a sub-sub form of [SubFrm Vol Opportunities] ~Data taken from [Tbl Actual Volunteers]. [SubFrm Volunteer List]: ~Child ~Has fields like [Volunteer ID] & [Event ID]. ~This subform is just used for reference and not for data entry. ~Data taken from [Tbl Actual Volunteers]. My question is, how can I make [SubFrm Volunteer List] display [Volunteer ID] as a recordsource for [subFrm Volunteer List] from the table to a query that joins [tbl Actual Volunteers] to [Volunteer ID], and then the fields will be there for you to put on 5 / 1 / 2010. I have an unbound form with two subforms on it [SubFrm Actual Volunteers] &

networked Q drive). x = Shell("C: \ Program Files \ Microsoft Office \ OFFICE11 \ WINWORD.EXE Q: \ Databases \ Volunteers \ 14 v0.2g Production \ VolunteerCardTemplate.doc", 1) I get an error message from Word along the path Try: x = Shell("C: \ Program Files \ Microsoft Office \ OFFICE11 \ WINWORD.EXE ""Q: \ Databases \ Volunteers \ 14 v0.2g Production \ VolunteerCardTemplate.doc""", 1) I am launching a mail merge process from networked Q drive). x = Shell("C: \ Program Files \ Microsoft Office \ OFFICE11 \ WINWORD.EXE Q: \ Databases \ Volunteers \ 14 v0.2g Production \ VolunteerCardTemplate.doc", 1) I get an error message from Word along

Any help would be greatly appreciated. Thanks. Access Modules DAO Discussions Geography (1) Autofill (1) Volunteers (1) Times (1) AAAZ (1) This is about the 4th or 5th time I have in many different places to see if your question was answered, it means that the volunteers who help out here may not realize that someone else has already answered your question

day only attendees. thank you. Access Discussions Database (1) Jhall (1) Peggy (1) Attendence (1) Volunteers (1) Meeteings (1) Meetings (1) Alsoif (1) Access will work fine. Peggy Sue. You've while this forum is sponsored by MS, almost ALL of the people who participate are volunteers who donate their experience and knowledge to ANSWER QUESTIONS regarding the MS Access database application