Tag: Expressions

Calculating Age using Date of Birth
Microsoft Access

Calculating Age using Date of Birth

sunshinenerdLeave a comment

Creating field in form To add a field that will calculate a customers age using their date of birth: Open up the form you wish to add the field. Under the HOME tab, click on the “View” drop-down option located in the ribbon on the far left and change to “Design View”. Insert a “text”… Continue reading Calculating Age using Date of Birth

Microsoft Access Joining Names with Expressions
Microsoft Access

Microsoft Access Joining Names with Expressions

sunshinenerdLeave a comment

In this post I will show you how to join customer names (customer plus spouse) and customer salutations. This is very useful when doing Microsoft Word merges into form letters. Open up the Query that you want to create a field for joining customer names and salutations. You will need the customers first name, last name, salutation,… Continue reading Microsoft Access Joining Names with Expressions