Recent content by NoelleW

Fabulous. Thanks!

Awesome, thanks! And if I need to have something conditional? e.g., [Field]= 'Homeless' or [Field]='Shelter'....how do i nest the Or in there?

The question is have they EVER been homeless...not what their current status is.

Yes, I've used that in the past. But in this instance, no sort order makes sense. I simply want if ANY record has X as the value in the field, then return "YES". Could be earliest, most recent, or any record in between...

Thanks for the reply. I'm creating the UNIQUE table as an interim step to export the data into another software package for reporting only. it isn't part of the ongoing data entry/storage. I still am not understanding how to "control" the IIF so that it takes the value I am looking for out...

I have two tables. One with multiple records per person (MULTIPLE). One with a single record per person (UNIQUE) (see below samples). I want to update the UNIQUE table based on multiple records/values from the MULTIPLE with various conditions. For example, if any of the records for a given...