K
Kara
I'm not sure if this is do-able in a query or at all, but here's my goal:
I have a table with student information and awards. I have a query running
off the table to check eligibility for certain awards (multiple criteria
rows).
Anyone returned in the query has some type of eligiblity problem. I'd like
to add a column that shows which criteria the student was returned under.
Ex: columns for Residency and AwardCode
Criteria1: residency=International Awardcode=In('Awd1','Awd2')
Would like to indicate that the students were returned in the query because
they are not eligible for awd 1 and awd 2 because they're international.
Does this have to be done with separate queries? Or is there a better way?
Thanks for any insight,
I have a table with student information and awards. I have a query running
off the table to check eligibility for certain awards (multiple criteria
rows).
Anyone returned in the query has some type of eligiblity problem. I'd like
to add a column that shows which criteria the student was returned under.
Ex: columns for Residency and AwardCode
Criteria1: residency=International Awardcode=In('Awd1','Awd2')
Would like to indicate that the students were returned in the query because
they are not eligible for awd 1 and awd 2 because they're international.
Does this have to be done with separate queries? Or is there a better way?
Thanks for any insight,