Microsoft Access

Calculating Age using Date of Birth

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

Microsoft Access Joining Names with Expressions

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