Craig is working in a database that stores homes for sale for a Realtor. The database contains a table called HomeListings which contains a field called ListingDate that holds the date that a home was listed. Craig is designing a query that will identify houses on the market for less than 30 days as new listings, and houses on the market 30 days or more as old listings. This information will be included in a query column called ListingAge. Which of the following expressions will achieve these results: A) ListingAge: IIf(Date-[HomeListings]![ListingDate]30,"New Listing","Old Listing") C) ListingAge: IIf(Date-[HomeListings]![ListingDate]

Question

Craig is working in a database that stores homes for sale for a Realtor. The database contains a table called HomeListings which contains a field called ListingDate that holds the date that a home was listed. Craig is designing a query that will identify houses on the market for less than 30 days as new listings, and houses on the market 30 days or more as old listings. This information will be included in a query column called ListingAge. Which of the following expressions will achieve these results:
A) ListingAge: IIf(Date-[HomeListings]![ListingDate]<30,"New Listing","Old Listing")
B) ListingAge: IIf(Date-[HomeListings]![ListingDate]>30,"New Listing","Old Listing")
C) ListingAge: IIf(Date-[HomeListings]![ListingDate] < 30, "Old Listing","New Listing")
D) ListingAge: IIf(Date-[ListingDate]![HomeListings]<30,"New Listing","Old Listing")

Quizplus · Accepted Answer

The correct expression is A) ListingAge: IIf(Date-[HomeListings]![ListingDate]<30,"New Listing","Old Listing") because it correctly calculates the number of days a listing has been on the market by subtracting the listing date from the current date (using the Date function). If the result is less than 30, it labels the listing as "New Listing"; otherwise, it labels it as "Old Listing".

Craig Is Working in a Database That Stores Homes for Sale