Jet reports adds the NL (NAV Lookup) worksheet function to Excel. This function retrieves data from your NAV database based on the function parameters that you set.
The first three parameters of the NL function specify what to retrieve, the table, and the field. The fourth, fifth and following parameters specify the filters.
=NL("what to retrieve","table name","field name","filter field","filter value")
For each filter, you include two parameters: the filter field and the filter value.
If the first parameter (the "what" parameter) is blank, Jet retrieves the first record that matches the filters. You can also use "Sum" to sum up values in a field or "Count" to count records in a table.
The easiest way to get this function is to use the Jet Browser to drag the Phone field out of the Customers table with the Browser drag-and-drop keyword option set to First. You now have an NL function without the filters. You can add the filters using the Jet Function Wizard (Jfx).
