Query to Set Value Based off another Column
Competent Performer
Windows 8 
Access 2013
I'm doing a self-storage unit management database..basically I need to query to find out whether a unit is available or not. So my unit table has a FK of TenantID so I just want it to check and see if TenantID is null and return "Available" or "Occupied" if not null.
Access Developer
Windows XP Access 2003
Perhaps something like:
Expr1:Iif(IsNull(TenantID),"Available","Occupied")
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Competent Performer
Windows 8 Access 2013
Thank you that worked!
Return Value in Select Query based on criteria in another column of Query
Return sum column based on another column Where statement date minus x months
Posting Permissions
Reply With Quote