Extracting data using Microsoft Query directly

CurrentSemesterOnlyFlag

Only view data from the current year and semester. The default value in this field changes depending on the user's Synergetic preferences.

It is preferable to use the CurrentSemesterOnlyFlag rather than FileYear and FileSemester fields.

FileYear

Use to set the current year, to avoid using information from previous or future years.

FileSemester

Use to set the current semester, to avoid using information from previous or future semesters.

For example, when using FileYear and FileSemester:

If using the same query three years from the date of creation, you will need to reset these filters to match the current year and semester. These selections would only be useful if you want to access prior years on the database.

ContactAddressFull

Gets the contact's address and organises it in a mailing format such as:

Synergetic Management Systems
Building 4, 303-313 Burwood Hwy
Burwood East VIC 3151

StudentContactAddressComma

Places commas in the address, used for listing names and addresses. For example:

Synergetic Management Systems, Building 4, 303-313 Burwood Hwy, Burwood East VIC 3151

These fields are constructed from the Address1-3, Suburb, State, PostCode and Country. They also take into account whether the current person is deceased or the address is no longer valid on the system.

StudentContactMailName

Defined by the MailFormat in Community Maintenance, this field is normally in the format of Contact Title and Contact Spouse Title Contact First Initial Surname.

For example, Mr and Mrs P Bailey.

StudentContactMailSalutation

Organises the ContactMailName in the format you have specified within Synergetic's Community Maintenance, MailSalutation.

For example, you can remove the contact's initial.

Surname

Used for sorting purposes.

You can later delete the field but keep the sorting. If you are using the wizard then you need to add it now.

StudentName

Student's Name and Surname joined together. It will be used later when doing a Mail Merge within Word.

If you want only the student's preferred name then you may need to join to another table or select a different field in the view.

For example, Brian Smith.

EntryDate / LeavingDate

The EntryDate and LeavingDate are used together to filter out students who are not at your organisation at a certain date.

All students should have an entry date, after which date they are present at your organisation, unless they have left.