How to Use Functions in MS Access Queries

In this video, we are going to learn how to use functions of different kinds in our MS Access queries. Using functions is a nice way to process very complex calculations by creating a calculated column in your query.

We will cover the usage of both Access “built-in” functions that are available to everyone, and custom functions that you can program yourself using VBA. You’ll find that there is a tight integration between Access and VBA, and this gives an incredible amount of power to query builders on this platform.

Related Videos:
How to Use Union Queries in MS Access
How to Split One Column Into Two in Access Using the Split Function
How to Query the Last Row in a Series in Microsoft Access
How to Format Dates in MS Access Queries, Forms, and VBA Code
How to Use Nz in Microsoft Access to Handle Null and Empty Values
How to Use Crosstab Queries in MS Access
How to Use Functions in MS Access Queries
You are watching this video now!

Follow us on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

MS Access Project? Contact me today!

Check out some of my earlier videos on MS Access:

[imstevemcqueen]

Sean should have many more views of his excellent content...ppl are missing out

[miles]

Hi Sean, per usual - found a use case for this. Love your channel, thanks!

[giuseppesantoro]

Le tue lezioni sono ben fatte e impirtanti...
Seguirò le lezioni anche se non parlo inglese.... Grazie molto.

[sd]

Thank you so much! This was very helpful!

[Nilkorbi]

I have a table with years. months and three other fields, 'assets' 'loans' and 'deposits'. I want the user to be able to chose through a Form (check boxes) which fields to to seelct for a query output. I have already set the criteria for selecting 'years from and to' and 'months from and to', but cannot figure how to make it possible for the user to seclect assets, loans and deposits (one of them, two of them or all three). Any help would be muhc appreciated

[AmpentoDAJHS]

Please lets say you have a data of some numbers like 1, 2, 4, 8, 2, 3. Can we get a query or a formula that will pick the least two figures and sum them up?

[m.arifganai]

Great plz let me know how to use sub routine functions in query or in update query based on criteria

[satyabanukil]

I have simple question. I have a query and there are two columns which are expressions. I want to know can I add those two expressions to another expression field. For example Expression 1 has 20 and Expression 2 is 10. Now I want to build a third expression column which will add expression 1 and expression 2 and expression 3 will show 30. If yes, what is the syntax. Regards.

[oparesimon]

Please, I have a challenge in a students results that I am currently analysing. It is possible to get help from you?

[shafameen]

Hi Sean, very useful vedio. Can you do a vedio on how to calculate sumifs using custom function in Access please.

[artistryartistry]

Hi there, can NZ() be put directly into the field in, say, a continuous field on a form vs. the QBE?

[rohitgondhali]

Hi Sir
Can you upload Detailed information video on Dlookup Function in MS Access
It will very helpful
Thank you

[lucagiraldes]

Hello! Can you tell me what i can do when i have two different tables, with the same column's name? How can i reference just one of these tables? Example: Function test (varID from table1)? Thanks a lot!!

[interestingamerican]

Is there a way for a function to pull values from not only the column it was placed (varID) but also another column related to that record? Basically allows me to use the primary key of the record for nefarious (: D)

Nevermind. Using [ ] in the function. I payed better attention. Thanks a

[rincondeolocuilta]

Hello! Thank´s for sharing knowledge. Can you tell me what a “?” do in the immediate window. Is that the way that immediate window recognizes that you are doing a “direct”test of a function?