MS Access: Datediff function return value?

Question

2 date fields: customer request delivery date and current date ( using date() ). i'm using the datediff function to get the date difference... In the query, i want to range the records by using between 1 and [the amount of days the user prefer to check (eg like a week as input 7)] ..also i would like the result going from the lowest to the highest (in order to show the urgency).. i tried it in so many ways to do this and having no luck at all... does anyone know how to solve my problem??

Answer 1

To sort them, just use ORDER BY in conjunction with the DateDiff function:



SELECT

DATEDIFF(d, DeliveryDate, Date()) AS DateDifference



ORDER BY

DATEDIFF(d, DeliveryDate, Date())

Answer 2

Access Datediff Function

Answer 3

In question layout, click the Totals button on the toolbar. this could open the completed row interior the Fields grid. Then replace the Values column to be Sum. flow away the Names column as team