Recent Posts • Latest Topics • Unanswered Questions

Craig is working in a database that stores homes for sale for a Realtor. The database contains a ta

Alandria

wrote...

Go to Answer

Posts: 2638

Rep:

9 years ago

Craig is working in a database that stores homes for sale for a Realtor. The database contains a ta

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")

Textbook

Exploring Microsoft Office 2010, Volume 1

Edition: 2^nd

Authors: Grauer, Poatsy, Hulett

Read 348 times

3 Replies

Report

Using Exploring Microsoft Office 2010, Volume 1, 2E

Replies

Answer verified by a subject expert

whatsmyname

wrote...

Related Topics

Alandria Author

wrote...

9 years ago

Wow! You are awesome. Thanks...

Report

Using Exploring Microsoft Office 2010, Volume 1, 2E

whatsmyname

wrote...

9 years ago

My pleasure!

Report

New Topic

Quick Reply

Explore

Post your homework questions and get free online help from our incredible volunteers

829 People Browsing

193 Signed Up Today

Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook

Live Chat

AJAX Chat © blueimp.net Integrated with SMF

Related Images

265

285

339

Your Opinion

Previous poll results: Who will win the 2024 president election?

It's sore throat season, why does my mucus have red spots?

The Toxic Skin and Fungi Defense

Strange Ingredients Lurking in Doritos Chips

Bonobos, Chimpanzees, and the 98% DNA Link

Courses by Biology Forums

Ready to ask a question on Biology Forums? Try it out

Join Our Community

Biology Forums - Study Force is a free online homework help service catered towards college and high school students. Get homework help and answers to your toughest questions in biology, chemistry, physics, mathematics, engineering, accounting, business, humanities, and more. Master your assignments quickly with thousands of step-by-step solutions to countless textbook questions asked and answered by our members. If we don't have your question, don't worry. You can ask any homework question and get expert homework help in as little as two hours.

Our extensive online study community is made up of college and high school students, teachers, professors, parents and subject enthusiasts who contribute to our vast collection of study resources: textbook solutions, study guides, practice tests, practice problems, lecture notes, equation sheets and more. With our help, your homework will never be the same!

Join for free today

How is Biology Forums - Study Force different than tutoring?

Home Search Q & A Board Gallery Resource Library Blog Dictionary Chat	Quick Links Start a Topic Latest Topics Unanswered Questions Courses Study Tools Browse by Textbook	Social Facebook YouTube Community Stats Who's Online Trending Staff	Help About Us Take the Tour Study Tips Posting Guidelines Terms and Policies Contact Us
Biology Forums - Study Force © 2010-2024 \| Powered by SMF \| SMF © 2015, Simple Machines \| Sitemap Biology-Forums.com is not affiliated with any publisher. Book covers, title and author names appear for reference only.