Use the AP database Vendor name from the vendor table Vendor Contact First Name and Vendor Contact Last Name from the ve

[answerhappygod]

Use The Ap Database Vendor Name From The Vendor Table Vendor Contact First Name And Vendor Contact Last Name From The Ve 1 (35.6 KiB) Viewed 28 times

output:

Use The Ap Database Vendor Name From The Vendor Table Vendor Contact First Name And Vendor Contact Last Name From The Ve 2 (36.56 KiB) Viewed 28 times

Use the AP database Vendor name from the vendor table Vendor Contact First Name and Vendor Contact Last Name from the vendor table but I need them concatenated together with a space between the names Invoice Date from the invoice table Only the day of from the Invoice Date Invoice Number from the invoice table The third and fourth characters from the Invoice Number Line Item Amount from the invoice line items table Calculate the commission which is the Line Item Amount * 15% and make it ONLY two decimals The FROM is the Vendors table do JOINS on the others The WHERE is where the Line Item Amount is greater than $2000 and the Invoice Date is between July 1, 2014 and July 31st, 2014 and I only want the ones that have either a 9 or a 2 in the Invoice Number Sort by Invoice Date Column heading names MUST match mine, see printout below
Tools Scripting Help Tesi#1 Limit to 1000 rows 19 Result Grid Filter Rows: Exports | Wrap Cell Content E Vendor Contact InvDate Dayof invoice ThirdFourth Amount Commission United Parcel Service Violet Beauregard 2014-07-01 01 989319-467 93 2318.03 347.70 Malloy Lithographing Inc Abe Regging 2014-07-19 P-0259 02 26881.40 4032.21 United Parcel Service Violet Beauregard 2014-07-23 989319-417 93 2051.59 307.73 Malloy Lithographing Inc Abe Regging 2014-07-24 24 0-2060 20 23517.58 3527.63 United Parcel Service Violet Beauregard 2014-07-24 24 989319-447 93 3689.99 553.49 Malloy Lithographing Inc Abe Regging 2014-07-31 31 0-2436 24 10976.06 1646.40 gs 23