MS Access 2007 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 7: MS Access Built-In Functions
Step 2: Right Click on Empty Column & Click ‘Build’
Figure 7-3: Building Formula/Expression field.
________________________________________
1. As shown in the Figure 7-3 with label 1, right click in this empty
area. As a result of which a window will popup.
2. Click the ‘Build’ command in order to access the Expression Builder
window.
You can use any table for your query as a data source. In this example
we are using ‘My Test Table’. It’s a very simple table having following
fields.
FIRST_NAME
LAST_NAME
HIRE_DATE
DEPARTMENT_NAME
In the query builder we are selecting all the fields and we would like
to create one more field which will be depended on HIRE_DATE field. You
can also call this field as derived field as its values depends on the
values inside the HIRE_DATE field.
We would like to create a field containing the Years of Service for
every person in the department. Follow points 1 and 2 as mentioned in
the start of discussion of this article to access the ‘Expression
Builder’ window. We use this window to create all sorts of ‘Derived’
fields and whenever and wherever there is a need for building and using
MS Access built-in functions.
Chapter 7: MS Access Built-In Functions
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: