Hello,
I am working with an access database containing locker numbers, names, shifts, etc. I have a query set up to show me the empty lockers using the "null" criteria. Now I want to add an expression that will look up the information already associated with the locker number (aka the other person in that locker, their shift, etc). I'm thinking of using an IIF with a nested lookup but I'm struggling with how to write the expression to get the data I want. Any suggestions?
Example of data:
NAME PHONE STATUS Tue_SHIFT Wed_SHIFT Thu_SHIFT Fri_SHIFT Sat_SHIFT 1__WEEK 2__WEEK 3__WEEK 4__WEEK 5__WEEK Locker_NO
MaryAnne XXX-XXX-XXXX Employee 1 X X X X X 128
"Empty" XXX-XXX-XXXX ABCDEF 128
Query shows Locker 128 is available for use by another individual. Now I want to write an expression that will look up "MaryAnne and associated data".
Regards,
MaryAnne