DCount Function

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. You can use the DCount function to determine the number of records that are in a specified set of records (a domain). Use the DCount function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control. For example, you could use the DCount function inContinue reading “DCount Function”

DFirst, DLast Functions

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. You can use the DFirst and DLast functions to return a random record from a particular field in a table or query when you simply need any value from that field. Use the DFirst and DLast functions in a macro, module, query expression, or calculated control on a form or report. Syntax DFirst ( expr , domain [,Continue reading “DFirst, DLast Functions”

DMin, DMax Functions

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. You can use the DMin and DMax functions to determine the minimum and maximum values in a specified set of records (a domain). Use the DMin and DMax functions in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control. For example, you could use the DMin and DMax functions in calculatedContinue reading “DMin, DMax Functions”

DSum Function

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. You can use the DSum function to calculate the sum of a set of values in a specified set of records (a domain). Use the DSum function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control. For example, you can use the DSum functionContinue reading “DSum Function”

DLookup Function

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. In Access desktop databases you can use the DLookup function to get the value of a particular field from a specified set of records (a domain). Use the DLookup function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control on a formContinue reading “DLookup Function”

Weekday Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Integer) containing a whole number representing the day of the week. Syntax Weekday( date [, firstdayofweek ] ) The Weekday function syntax has these arguments: Argument Description date Required. Variant, numeric expression, string expression, or any combination of these that can represent a date. If date contains Null, Null is returned. firstdayofweek Optional. AContinue reading “Weekday Function”

DateSerial Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Date) for a specified year, month, and day. Syntax DateSerial ( year, month, day ) Warning  –  Make sure the arguments are in the correct range of values. An invalid argument can result in an incorrect result. The DateSerial function syntax has these arguments: Argument Description year Required. Integer. NumberContinue reading “DateSerial Function”

DatePart Function

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Integer) containing the specified part of a given date. Warning   – There is an issue with the use of this function. The last Monday in some calendar years can be returned as week 53 when it should be week 1. For more information and a workaround,Continue reading “DatePart Function”

DateDiff Function

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Long) specifying the number of time intervals between two specified dates. Syntax DateDiff ( interval, date1, date2 [, firstdayofweek] [, firstweekofyear] ) The DateDiff function syntax has these arguments: Tip: In Access 2010, the Expression Builder has IntelliSense, so you can see what arguments your expression requires.  Argument Description interval Required. String expression thatContinue reading “DateDiff Function”

DateAdd Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Date) containing a date to which a specified time interval has been added. Syntax DateAdd ( interval, number, date ) The DateAdd function syntax has these arguments: Argument Description interval Required. String expression that is the interval of time you want to add. number Required. Numeric expression thatContinue reading “DateAdd Function”