Data Filter - I think??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data base in which the item may be passed to up to 3 different
people for input. I have 3 fields -Person #1, Person #2, Person #3. I want
to run a report that only gives me that last person's name the report was
passed to.
Basicly if Person #3 is not void, than enter that name
If Person #3 is void,go to person #2
If person #2 is not void, then enter that name
If person #2 is void, then go to person #1.

Is there any way to do this?
 
Having repeating fields (Person1, Person2, ...) is what you do in a
spreadsheet when you have a one-to-many relationship.

In Access, you add a table that holds the "many" side records.

In a spreadsheet, you look "across" to see the last one filled.

In Access, you look "down" to find the most recent entry.

That said, you could still create an expression in a query using the IIF()
function nested inside the IIF() function to pick the "last" person entered
across. It won't be pretty, and it WILL need to be modified if you ever
change the number of persons...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top