I\'m not sure how I could add an access file on here. But I need help with this

Question

I'm not sure how I could add an access file on here. But I need help with this step in my project. I am clueless when it comes to access. I hoping to get some steps to get started. Thanks

Create a query to calculate the number of days between the date an order was placed and the date the order was shipped for each order. Use Query Design, from the Customers table, include the fields CompanyName, ContactName, ContactTitle, and Phone; from the Orders table, include the fields OrderID, OrderDate, and ShippedDate; from the Order Details table, include the Quantity field; from the Products table, include ProductName field. Add a calculated field named DaysToShip to calculate the number of days taken to fill each order. (Hint: The expression will include the OrderDate and the ShippedDate; the results will not contain negative numbers.) Add criteria to limit the query results to include any order that took more than 30 days to ship in the past six months (based on the dates in the file, not actual time). Sort the query by ascending OrderID.

Explanation / Answer

The query should be something like:-

SELECT DATEDIFF( d, orderDate, shippedDate) AS daysToShip FROM 'ORDER' LIMIT 0,30 ORDER BY OrderID ASC.

The query is self explanatory DATEDIFF function calculates the days between two dates and is storing the result in daysToShip. LIMIT 0,30 is helping us putting restriction that number should be positive and should be less than 30. And order by is helping us ordering records in ascending order with respect to order id.

Hope this will help!!!!!

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.