Any entry that is a Record can be double-clicked to open its Property BoxThe Property Box is the primary window for data entry and for viewing details of stored records.  It is used with records of all types.   to review or edit fields.

Any entry that is a Data Field can be right-clicked to choose Locate in Property Box or Locate in All Tab.

Any entry that is a Data Field can have its contents deleted by pressing the DELETE key. Also, by selecting multiple entries such as an entire column, then bulk deletes can be applied.

It is possible to Print the Results Set from a Query, and there are Print Detail options to configure the printed output on the General tab of the Query Window.

Most of the Print Details options are self-explanatory, but the Title and Subtitle Custom options have some undocumented features to incorporate any Value entered via a Rows Tab prompt for a Parameter. Any such Value is represented by [“Prompt”], where Prompt is the name of the parameter Label, and to include it in the Title or Subtitle it must be enclosed in a Type Specifier Function of a matching type: Text([“Prompt”]), Number([“Prompt”]), Individual([“Prompt”]), Date([“Prompt”]), etc.
e.g. Date =Number(["Day"]) of =Text(["Month"]) for =Individual(["Person"])

Since ƒh V6 the Save Results to File menu offers two Save As Comma-Separated CSV File options for UNICODE UTF-8 and ANSI encoding, but some spreadsheet programs do not handle UNICODE UTF-8 well, so try both options, or even the Save As Text File options with either Tab character or Comma as the Column separators. See also How to Open UTF-8 in Excel 2013-2016 and How to Import CSV file that uses UTF-8 in Excel 2007.

You should note that Excel (as shipped) does not support DatesWhen an Event happened, or an Attrribute was true. earlier than 1 January 1900.  There are two approaches to dealing with this:

1. Use numerical columns for Day Month and Year in your queries if you intend to export them to Excel.
2. If you’re very comfortable with Excel, explore the techniques in How to Work with Dates Before 1900 in Excel

You can create your own custom queries — see Searching and Querying Videos for video tutorials on how to do so.

Or you can download a Custom Query that somebody else has written (for example from the Queries section of our Downloads page or the FHUG forums). If you download a Custom Query, you must install it before you can use it. The simplest way to do so is to double-click on the file to open it; ƒh will automatically install it.

It is important to consider which type of Query will be most useful for the problem you want to solve.

• • Individual queries are the most popular. They return a set of Individual recordsEvery person in your tree will have a single Individual Record, which holds all the information about that individual that you have entered.  You can view and edit Individual records in the Property Box Dialogue.; the columns can include records linked to an Individual (e.g. Family or Source records, or Individual records for spouses and children).For example, if you want to identify a set of Individuals who meet a set of criteria (e.g. Male Individuals who were born between two specified years and still alive in 1914, so might have legally served in World War 1) an Individual query is what you need.However, to show more than a few selected Facts in the Result Set will require a Column for every field of each and every type of Fact plus each and every instance of multiple Facts such as Census. That could run to dozens if not hundreds or thousands of Columns.If your focus is on the Facts for a set of Individuals, consider a Fact Query instead.

• • A Fact Query focuses on Facts, not records, but the Columns and Rows can refer to any items, including records associated with a Fact.For example it can include, each in a different Column, the Individual or Family record that owns the Fact, or any Source recordsSource: "where information was found". This could be anything from an archive in a county records office, a book, or even a relative's recorded recollection. Citing your Sources helps to show how you reached a particular conclusion about an Individual. cited by the Fact However, each Row in the Result Set is keyed to just one unique Fact, and that Fact is only represented on one Row.So, if you want to view all the Education Facts for people in your family tree, a Fact query is what you want.
  • Family queries will return a list of Family recordsFamily records store information about families, and links to all the Individual Records for those individuals who make up a family. You can view and edit Family records in the Property Box Dialogue. that meet your chosen criteria.So, if you want to see a list of couples who married between two dates in a particular placeAccording to GEDCOM, a Place should hold "The jurisdictional name of the place where the event took place…"  , a Family query is what you want.
  • You can also construct Queries based on MediaWhen you add a picture, video, sound recording, document file etc into a Family Historian project, a Media record is created to represent that media item within the project; the Media record includes a link to the actual Media file., Note, Place and Repository recordsA repository is a place (physical or online) where collections of original source data are stored and maintained..For example, you can query to see all the Sources you consulted at a particular Repository.

In the Columns Tab:

• • Data Reference Fields are chosen using the Fields pane on the left. Click on any + sign to expand a sub-list, and having selected a Field, click on the Add Field as Column button > at the bottom. This will add a Heading and an ExpressionExpressions are composed from two technical features: Data References and Functions; they also often involve Operators to compare values. to the Columns pane on the right.Although these Columns are listed vertically, they will appear horizontally in the Result Set, and moving them up and down, actually moves them left and right in the results.
  • If you have created Text Schemes in Diagrams, then these Expressions are almost identical, and similarly can include FunctionsA 'function' is an expression which returns values based on computations. Typically, functions require data to be supplied to them as 'parameters'. A function in Family Historian is similar to a 'function' as used in spreadsheet applications (such as MS.Look at other Queries and you will see how they use Fields and Query Functions. For an Introduction to Data ReferencesData references are expressions which are used to provide a way of referring to particular items of data in your project, such as records or particular fields within records. They can be used for advanced customizations of diagrams, websites, family and Functions see Understanding Data References and Understanding Functions.
  • Remember that many Data Reference Fields can have more than one instance, but only the first one is added by default.For example the Individual > Name field has an Expression of %INDI.NAME[1]%. If any Individual has Alternate Names then %INDI.NAME[2]% and %INDI.NAME[3]% will also exist, and these must be entered as extra Columns and the index adjusted to [2] or [3] by hand.It is easily overlooked that AttributesEvents are things that happened to an Individual and Attributes are things that described them., Events, Sources, and many other fields often have multiple instances that need to be incorporated.

In a Fact Query the Owner of the Fact is displayed using one of these Column Expressions:

• =FactOwner(%FACT%,1,MALES_FIRST) for Family Fact Husband or Individual Fact Owner.
• =FactOwner(%FACT%,2,MALES_FIRST) for Family Fact Wife (otherwise blank).
• =GetRecord(%FACT%) for Family Fact Husband & Wife record or Individual Fact Owner record.

They all display the name of the owner with forenames first and surname last, so it is not possible to sort them in surname order. The following column expressions allow you to obtain surname sort order.

These Column Expressions work in FH V5 and above:

• =FieldText(FactOwner(%FACT%,1,MALES_FIRST),'INDI.NAME:SURNAME_FIRST') which displays the surname first, and sorts in surname order, but is NOT an active link to the Individual record.
• =Field(FactOwner(%FACT%,1,MALES_FIRST),'INDI.NAME') which still displays forenames first, but sorts in surname order, and is an active link to the Individual record.

For FH V6 and above, those two Expressions can be combined into one Result Set Column that exhibits the best features of both:

• 1st Column uses Expression: =FieldText(…) with Sort: None and Type: Normal so appears in Result Set.
• 2nd Column uses Expression: =Field(…) with Sort: Ascending and Type: Buddy so is hidden, but defines the sort order of 1st Column and provides an active link.