Practically every food you buy in a store for consumption by humans is genetically modified food. There are no wild, seedless watermelons. There's no wild cows.
This is the query I am using SELECT Student_Course.MailMerge, Student_Course.FieldPlacementID, Student.Fname AS StudentFirstName, Student.Lname AS StudentLastName, FAST_StudentAddresses.Term, FAST_StudentAddresses.[Email Address] AS StudentEmail, AgencyInformation.Agency, AgencyInformation.Address, AgencyInformation.CityID AS City, Contact.FirstName AS ContactFirstName, Contact.LastName AS ContactLastName, Contact.Phone AS ContactPhone, Contact.Ext AS ContactExt, HyperlinkPart([Contact].[Email],1) AS ContactEmail, Student_Course.SentStudentConfirmation, Student_Course.SentAgencyConfirmation FROM (Contact RIGHT JOIN (AgencyInformation RIGHT JOIN (Student RIGHT JOIN Student_Course ON Student.StudentID = Student_Course.StudentID) ON AgencyInformation.AgencyID = Student_Course.AgencyID) ON Contact.ContactID = Student_Course.ContactID) LEFT JOIN FAST_StudentAddresses ON Student.StudentID = FAST_StudentAddresses.[Spriden ID] WHERE (((Student_Course.MailMerge)=True) And ((Student_Course.FieldPlacementID)=Forms!Menu_StudentFieldPlacements!cboFieldPlacement) And ((FAST_StudentAddresses.Term)=Forms!Menu_StudentFieldPlacements!cboTerm));
Reply from Alex Hedley:
That contains a few parameters Forms!Menu_StudentFieldPlacements
Did you try the suggested article?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.