If and then multiple statements - how do I do it?

[nomi123]

In a report I am accessing two tables - one contains company criteria and one contains student information. I need an iif statment that will tell me which students meet the company's criteria. For example: I want to match all students whose gpa, major and citizenship match the company criteria. i.e. iif the students major is CS and their minimum gpa is >2.5 and their citizenship is citizen or PR then they quality for this company.

[June7]

Do you have a query that joins the two tables on the 3 criteria fields?

Then create field in query with expression:

IsMatch: IIf(Student.Major=Company.Major AND Student.GPA=Company.GPA AND Student.Citizenship=Company.Citizenship, True, False)

[alansidman]

In a query, use the student table as your recordset. Set the criteria for each field in the grid. Run the query. The end result will be filtered on your established criteria.

http://office.microsoft.com/en-us/tr...aspx?section=2

http://www.baycongroup.com/access2007/05_access.html

http://www.youtube.com/watch?v=nxBUQ_ZuGtI