IIF Function

[Gus]

Hi All

I am relatively new to access 2010 but have a little knowledge of earlier versions.
My problem is, How can i write a a function or query to tell if a book has been borrowed from my library. I have a table tblauthortitle with fields by Author,Book Title, Borrowed By, Date Borrowed and Return Date.


Below is the Qurey i am running but is shows #Error in what should be Unavaiable

Status: IIf([Date Borrowed]="Date","Unavailable","Available")

SQL Statement
SELECT tblauthortitle.Author, tblauthortitle.[Book Title], tblauthortitle.[Borrowed By], tblauthortitle.[Date Borrowed], tblauthortitle.[Return Date], tblauthortitle.Lender, IIf([Date Borrowed]="Date","Unavailable","Available") AS Status
FROM tblauthortitle;

Thank You.
Gus

[boblarson]

Status: IIf([Date Borrowed]=Date(),"Unavailable","Available")

would be the way to use it. But what about tomorrow? If the date borrowed doesn't equal the current date then it would say available when it was really unavailable. You should probably be using RETURN DATE instead:

Status: IIf(IsNull([Return Date]),"Unavailable","Available")

[Gus]

Hi Bob,
Second suggestion Status: IIf(IsNull([Return Date]),"Unavailable","Available") works a treat, just reversed Unavailable and available to get desired result. Im a Daycare officer trying to design a library Database for the Centre in my spare time. i will definitely require your help, if thats ok in the future make that near future.

Kind Regards.
Gus