See Also:
Office.com results
Create an expression
Article An expression is like an Excel formula: it may include constants, variables, and functions. You can use expressions with most database objects.
Access 2007
DateAdd Function
Article Show All Hide All Returns a Variant ( Date ) containing a date to which a specified time interval has been added. Syntax DateAdd ( interval, number, date ) The ...
Access 2007
DatePart Function
Article Returns a Variant ( Integer ) containing the specified part of a given date. Syntax DatePart ( interval, date [ , firstdayofweek ] [ , firstweekofyear ] )...
Access 2007
Day Function
Article Returns a Variant ( Integer ) specifying a whole number between 1 and 31, inclusive, representing the day of the month. Syntax Day( date ) The required date ...
Access 2007
Examples of expressions
Article This article provides examples of expressions. An expression is a combination of mathematical or logical operators, constants, functions, table fields, controls...
Access 2007
Format Function
Article Returns a Variant ( String ) containing an expression formatted according to instructions contained in a format expression. See some examples Syntax Format(...
Access 2007
Now Function
Article Returns a Variant ( Date ) specifying the current date and time according your computer's system date and time. Syntax Now Example Note Examples that fo...
Access 2007
Weekday Function
Article Returns a Variant ( Integer ) containing a whole number representing the day of the week. Syntax Weekday( date [ , firstdayofweek ] ) The Weekday functi...
Access 2007
Year Function
Article Returns a Variant ( Integer ) containing a whole number representing the year. Syntax Year( date ) The required date argument is any Variant , numeric e...
Access 2007