User Profile
amasikonde
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Help with a Query to return "OrderID" with no OrderDate
I need help to write an Access query to turn OrderID with no Corresponding OrderDate. The Table I'm using is as shown below: OrderID OrderDate CustID ProductID SalesID 10000 1/10/2005 2461 REFI128 9093 10001 1/10/2005 2905 ALBE008 5631 10002 1/12/2005 2938 EXVI008 6957 10003 2011 EXVI008 3729 10004 1/12/2005 2143 PICH008 5293 10005 1/13/2005 2952 HOJI064 8598 10006 1/14/2005 2726 EXVI016 1174 10007 1/15/2005 2820 MORA128 8123 10008 1/15/2005 2665 KORO016 6669 10009 2302 VIRG064 1207 10010 1/16/2005 2683 MORA128 5631 10011 1/17/2005 2662 FRAN128 6870 10012 2981 KORO016 5631 10013 1/18/2005 2162 MORA128 7634 10014 1/20/2005 2390 PICU032 1174 10015 1/21/2005 2732 OBLI128 9584 10016 1/21/2005 2062 PURE032 6957 10017 2233 MANZ016 7634 10018 1/22/2005 2144 PICH008 2234 10019 1/22/2005 2156 REFI064 6957 10020 2694 PURE032 1207 10021 1/24/2005 2956 ALBE064 7634 10022 1/24/2005 2932 PEND128 4105 10023 1/26/2005 2461 KORO128 2998 10024 2895 PEND016 6870 10025 1/27/2005 2397 LIGH064 6372 10026 1/28/2005 2934 MANZ128 1644 10027 1/30/2005 2938 FRAN008 5692 10028 1/31/2005 2219 REFI008 4747 10029 2/1/2005 2809 HOJI128 9584 10030 2/2/2005 2799 MANZ064 8972 10031 2553 OBLI016 9900 10032 2/4/2005 2022 REFI016 82741.2KViews0likes4CommentsProblem Converting Fiscal Year to Calendar Dates
I need help using a query to convert Fiscal year to Calendar Year. For Example, I have the Fiscal_Year column and Fiscal_Quarter Column, as shown below Fiscal_Year Fiscal_Qtr Calendar_Year FY21 4Q FY22 4Q FY21 2Q FY24 4Q FY24 2Q I need help coming up with a query of converting the Fiscal year to normal calendar dates group of Month/Date/Year(mm/dd/yyyy). if it is Fiscal_Year FY21 and Fiscal_Qtr is 4Q, then the date should be 9/30/2021, and if it is Fiscal_Year FY21 and Fiscal_Qtr is 2Q then the Calendar_Year should be 06/30/20212KViews0likes4CommentsHelp with MS Access query to return Brand sold 1 year after purchase date
I'm having problem writing a query to return Brands of vehicles sold in less than 1 year from the purchase date. The data I'm using is as shown below. Brand Price Body Mileage EngineV Engine Type Registration Model Year Model Purchase Date Sold Daate Audi 23000 crossover 240 4.2 Petrol yes 2007 Q7 1/3/2016 9/10/2016 Audi 14200 vagon 200 2.7 Diesel yes 2006 A6 1/3/2016 6/14/2017 Audi 9500 vagon 165 2.7 Gas yes 2003 A6 Allroad 5/23/2016 6/19/2017 Audi 3500 vagon 250 2.5 Diesel no 1998 A6 5/23/2016 8/10/2016 Audi 6800 sedan 225 2.4 Gas yes 1998 A6 5/23/2016 8/13/2016 Audi 24900 sedan 163 4.2 Diesel yes 2008 A8 5/23/2016 7/8/2017 Audi 6500 sedan 330 2.4 Petrol yes 1999 A6 8/15/2015 7/10/2017 Audi 2900 sedan 1 2.3 Gas yes 1989 100 10/10/2016 7/14/2017 Audi 33900 other 14 1.8 Petrol yes 2014 TT 10/18/2016 2/9/2018 BMW 4200 sedan 277 2 Petrol yes 1991 320 1/3/2016 9/7/2016 BMW 6100 sedan 438 2 Gas yes 1997 320 1/3/2016 9/13/2016 BMW 2990 other 203 2 Petrol no 2001 318 5/23/2016 6/23/2017 BMW 21500 other 72 3 Petrol yes 2007 Z4 10/11/2016 7/15/2017 BMW 28500 crossover 160 4.8 Gas yes 2008 X5 10/13/2016 2/4/2018 BMW 6000 sedan 300 2.8 Petrol yes 1996 528 10/16/2016 2/7/2018 BMW 67500 crossover 1 2.5 Diesel yes 2016 X5 10/17/2016 2/8/2018 Mercedes-Benz 7900 van 427 2.9 Diesel yes 1999 Sprinter 212 1/3/2016 9/8/2016 Mercedes-Benz 13300 sedan 358 5 Gas yes 2003 S 500 1/3/2016 9/9/2016 Mercedes-Benz 199999 crossover 0 5.5 Petrol yes 2016 GLS 63 1/3/2016 9/12/2016 Mercedes-Benz NA van 240 2.2 Diesel yes 2007 Vito 5/23/2016 8/8/2016 Mercedes-Benz 13566 other 171 2.2 Other no 2011 Vito 8/15/2015 7/11/2017 Mercedes-Benz NA crossover 0 4.6 Petrol yes 2016 GLS 500 8/15/2015 7/13/2017 Mitsubishi 10500 crossover 130 2.4 Gas yes 2006 Outlander 5/23/2016 8/14/2016 Mitsubishi 8500 hatch 65 1.3 Petrol yes 2010 Colt 8/15/2015 7/12/2017 Mitsubishi 17900 crossover 87 3.8 Gas yes 2008 Pajero Wagon 10/12/2016 2/3/2018 Renault 10799 vagon 193 1.5 Diesel yes 2012 Megane 1/3/2016 6/15/2017 Renault 11950 vagon 177 1.5 Diesel yes 2011 Megane 1/3/2016 6/17/2017 Renault 2500 sedan 260 1.79 Petrol yes 1994 19 1/3/2016 6/18/2017 Renault 8600 hatch 84 1.5 Diesel yes 2012 Clio 5/23/2016 6/22/2017 Toyota 18300 crossover 120 2 Petrol yes 2011 Rav 4 1/7/2016 9/11/2016 Toyota 16000 crossover 250 4.7 Gas yes 2001 Land Cruiser 100 5/23/2016 6/21/2017 Toyota 26500 crossover 21 2 Petrol yes 2013 Rav 4 5/23/2016 8/9/2016 Toyota 38233 other 0 2.4 Diesel yes 2016 Hilux 5/23/2016 8/11/2016 Toyota 14500 sedan 147 2.4 Gas yes 2006 Camry 10/15/2016 2/6/2018 Volkswagen 1400 other 212 1.8 Gas no 1999 Golf IV 1/7/2016 6/16/2017 Volkswagen 10500 sedan 100 1.8 Petrol yes 2008 Passat B6 5/23/2016 6/20/2017 Volkswagen 7500 hatch 132 1.4 Diesel yes 2006 Polo 5/23/2016 8/12/2016 Volkswagen 20800 crossover 151 3 Diesel yes 2008 Touareg 8/15/2015 7/9/2017 Volkswagen 9800 van 160 1.9 Diesel yes 2009 Caddy 10/14/2016 2/5/2018Solved3.8KViews0likes14Comments
Groups
Recent Blog Articles
No content to show