The following name the aging date input cell

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: or equal to 3/31/14, the date of the most recent transaction. Note: the Transactions Table is named tbl_invoices. Note: the Categories Table is named tbl_age. Write the formula needed to compute the Days Open column of the Transactions Table. Write a lookup formula to compute the Category column of the Transactions Table. Write the formulas needed to compute the Total column of the Report. Add a total row to tbl_invoices. Ensure that the total of the Report agrees to the total of tbl_invoices. Settings Aging date 4/30/2014 Report Category 0-30 31-60 61-90 91+ Total Total $- Categories Days Open Category 0 0-30 31 31-60 61 61-90 91 91+ Transactions ID CustID 45469 UPS102 50716 SAT017 46060 RAM101 46756 QEX711 48250 HBC160 50520 DOP090 46136 QCM550 50624 PBS408 49109 PBS408 45192 LHC001 47507 RAM101 48845 GRA182 50168 LHC001 49124 HBC160 46492 QCM550 50054 QCM550 50614 ATM201 45667 STR202 49561 SAT017 45379 DIG290 50313 NEW011 45419 POL412 50087 RAM101 46556 GRA182 47934 EBD220 49417 QCM550 Date 2/8/2014 2/27/2014 9/15/2013 1/1/2014 8/17/2013 8/6/2013 3/18/2014 2/28/2014 10/12/2013 2/10/2014 2/18/2014 2/26/2014 3/6/2014 10/11/2013 2/6/2014 2/1/2014 9/23/2013 11/2/2013 9/28/2013 3/24/2014 10/19/2013 3/6/2014 9/23/2013 3/9/2014 11/26/2013 3/31/2014 Amount $12,196 $10,249 $11,529 $4,512 $6,016 $13,602 $6,590 $3,700 $4,275 $7,683 $19,364 $1,693 $12,807 $14,712 $7,067 $18,084 $2,277 $19,343 $8,767 $8,369 $2,766 $18,004 $4,240 $6,311 $10,328 $1,968 Days Open Category...
View Full Document

This note was uploaded on 03/28/2014 for the course ACC 562 taught by Professor Staff during the Spring '14 term at University of Arizona- Tucson.

Ask a homework question - tutors are online