An excellent video tutorial on how to use the Access database Expression Builder tool. It clearly explains the features of this powerful and useful tool making good use of the terminology with ‘jargon’ free explanations.
This tool can be used in a query, form, report, macro and to a lesser extent tables too and applies to all versions of Microsoft Access (as far back as you really need to go!).
Here’s a tip to bear in mind (especially when using this tool for a query). Before utilising the expression builder tool in a query, first save the query as it will not show all the fields for an unnamed query object limiting the flexibility of this tool.
In Access 2010, this tool has been updated and has a different look and feel to it but essentially can be used in the same way.
Tags: Access 2007, access database expression builder, calculating in an access query, calculating in an access report, datediff function in access, using expression builder
This is the right web site for everyone who would like to find out about this topic.
You understand so much its almost hard to argue with you (not that I actually will need to…HaHa).
You certainly put a brand new spin on a topic that’s been discussed for ages.
Great stuff, just excellent!