Operation Manual

Figure 247: Field for distance traveled calculations
Figure 248: Fuel economy calculation field
Note
When entering fields for these calculations, you must follow this format: table or
query name followed by a period follow by the field name. For hyphenated or
multiple-word names (table or query), use double quotes around the table or query
name. The query will then add the rest of the double quotes as in Figure 248.
Use the arithmetical symbol between the two. More than one calculation can be
done by using parentheses to group the arithmetical operations.
Step 9: Run the query and make some modification.
After we run the query to make sure it works correctly, we will hide all of the fields that we do not
need.
Figure 249: Result of running the fuel economy query
1) Click the Run Query icon in the Design Query toolbar (Figure 240). The results are in
Figure 249.
Notice that not all of the last column label is visible because some of the labels are long.
We can fix this problem by using an alias for many of the fields. The labels are replaced by
their aliases.
2) Add Aliases:
252 | Getting Started with LibreOffice 4.0