FMDepartment.com contains dozens of predefined queries (spreadsheets) for space, asset and employee information, but we realize that you will want your information presented your way. With our incredible "Create Query" interface you can quickly and easily select the fields to include in your spreadsheet.

Help users find relevant information in their spreadsheet by adding restrictions, pick lists and math calculations.Save queries into your library or add them to a module. Once your spreadsheet is displayed, you can cut-and-paste into other applications such as Excel or print in PDF format.

Features

• Select fields from the database to add to a query.
• Rearrange columns.
• Add pick lists to columns in the spreadsheet.
• Add restrictions such as number ranges or date ranges.
• Add a total to any column.
• Add math calculations.
• Add hyperlinks from data in the spreadsheet to other queries and forms.
• Name and Save queries.

<< Back