The Time() Function returns the current system time only and the Now() Function returns both the current system date and time.ĭepending on the data that you want to track, or store, or query, you have three built-in, easy-to-use functions to help with that task.

There are two very similar built-in functions Time() and Now(). All you have to do is write the name of the function and those open and close parentheses. This function does not require any function arguments or additional information. The Date() function is designed to return the current system date. Let us now understand the Date and Time functions − Let us now look into some examples of using built-in functions. On the other hand, they can also get quite complicated, with multiple arguments, field references, and even other functions nested inside another function. You can use functions even in macro arguments.įunctions can be quite simple, requiring no other information to be called, or, simply reference one field from a table or query. You can also use functions in an expression when you create a calculated field, or use the functions inside form or report controls. You can use functions in table properties, for example, if you want to specify a default value for a date/time field, you can use the date or the Now function to call up the current date/time information from your system, and input that value automatically. Functions can generally be used in queries, but there are other places that you can use functions. FunctionsĪ function is a VBA procedure that performs a task, or calculation, and returns a result. In this chapter, we will cover the basic structure, syntax, and use some of the more popular functions, and also the pitfalls, so that you can go exploring some of the other functions on your own.

In Access, there are close to a hundred built-in functions and it is almost impossible to cover every single one of them. In this chapter, we will be working with Built-in Functions.

Microsoft access 2013 tutorial youtube