Excel Spreadsheet Help Needed

SeanofZdead
Ch03Ex02_U10e.accdb
CustomerName CustomerEmail DateOfLastRental BikeLastRented TotalNumberOfRentals TotalRentalRevenue ID
Ashley, Amanda JA@somewhere.com 5/3/16 LightLift Pro 5.0 ¤ 485.00 1
Davidson Kaye KD@somewhereelse.com 7/5/16 Wonder Bike II 5.0 ¤ 375.00 2
Ching, Kam Hoong KHC@somewhere.com 5/15/16 Wonder Bike 1.0 ¤ 55.00 3
Collins,Giovanni GC@righthere.com 6/18/14 LightLift Pro 3.0 ¤ 155.00 4
Corning,Sandra SC@somewhereelse.com 2/3/15 Wonder Bike Supreme 3.0 ¤ 295.00 5
Maple, Rex RS@somewhere.com 7/13/16 Wonder Bike 1.0 ¤ 56.00 6
Corovic,Jose JC@somewhere.com 11/10/16 Wonder Bike Supreme 1.0 ¤ 55.00 7
Lane, Amanda BL@righthere.com 11/11/14 Wonder Bike 1.0 ¤ 47.00 8
Wei, Guang GW@ourcompany.com 11/26/15 Wonder Bike Supreme 5.0 ¤ 385.00 9
Dixon,Eleonor ED@somewhere.com 5/15/16 Wonder Bike 2.0 ¤ 108.00 10
Lee,Brandon BL@somewhereelse.com 5/4/14 LightLift Pro 1.0 ¤ 74.00 11
Duong,Linda LD@righthere.com 5/15/15 Wonder Bike Supreme 2.0 ¤ 285.00 12
Dixon, Amanda T JTD@somewhere.com 4/1/15 Wonder Bike Supreme 4.0 ¤ 285.00 13
Goston, Sayeh SG@righthere.com 9/20/16 Wonder Bike Supreme 2.0 ¤ 120.00 14
Spenser, William WS@somewhere.com 3/12/16 Wonder Bike 1.0 ¤ 47.50 15
Ray, Tony TR@righthere.com 9/20/16 Wonder Bike 5.0 ¤ 580.00 16
Ryan, Mark MR@somewhereelse.com 11/1/16 Wonder Bike 1.0 ¤ 42.00 17
Rikki, Nicole MR@righthere.com 3/12/16 Wonder Bike 3.0 ¤ 175.00 18
Scott, Bryan BS@somewhere.com 3/15/15 Wonder Bike 4.0 ¤ 185.00 19
Warrem, Jason JW@ourcompany.com 5/10/16 Wonder Bike 2.0 ¤ 160.00 20
La Pierre,Anna ALP@somewhereelse.com 3/13/15 Wonder Bike 1.0 ¤ 52.00 21
Angel, Kathy KA@righthere.com 9/13/16 Wonder Bike II 3.0 ¤ 275.00 22
Quigly, James JQ@somewhere.com 4/10/16 Wonder Bike II 1.0 ¤ 44.00 23
Casimiro, Catherine AC@somewhere.com 12/5/15 Wonder Bike 1.0 ¤ 52.00 24
McGovern, Adrian AM@ourcompany.com 3/15/15 Wonder Bike Tandem 1.0 ¤ 72.00 25
Menstell,Lori Lee LLM@ourcompany.com 10/16/16 Wonder Bike Supreme 1.0 ¤ 92.00 26
Jefferies David DJ@righthere.com 12/5/15 Wonder Bike Supreme 3.0 ¤ 175.00 27
Maple,Katy NN@somewhere.com 10/10/16 Wonder Bike Supreme 2.0 ¤ 84.00 28
Bosa, Victor VB@ourcompany.com 9/22/16 Wonder Bike Supreme 2.0 ¤ 120.00 29
Pham,Mary MP@somewhere.com 3/12/16 Wonder Bike 1.0 ¤ 45.00 30
Redmond, Louise LR@ourcompany.com 1/1/16 Wonder Bike 2.0 ¤ 140.00 31
Jordan, Matthew MJ@righthere.com 3/12/15 Wonder Bike Supreme 7.0 ¤ 645.00 32
Drew, Richard RD@righthere.com 10/1/15 Wonder Bike Tandem 1.0 ¤ 42.00 33
Adams, James JA3@somewhere.com 1/13/16 Wonder Bike II 3.0 ¤ 210.00 34
Garrett, James JG@ourcompany.com 3/12/16 Wonder Bike 1.0 ¤ 38.00 35
Lunden,Haley HL@somewhere.com 11/16/13 Wonder Bike 1.0 ¤ 52.00 36
UTran,Diem Thi DTU@righthere.com 5/2/14 LightLift Pro 5.0 ¤ 375.00 37
Austin, James JA7@somewhere.com 1/14/15 Wonder Bike 1.0 ¤ 55.00 38
Bernard, Steven SB@ourcompany.com 9/15/16 Wonder Bike 1.0 ¤ 78.00 39
Daniel, James JD@somewhere.com 1/16/16 Wonder Bike II 4.0 ¤ 252.00 40