1. How to create a query
  2. On the Criteria tab expand Vendor and select Vendor ID.
  3. Click Select to move it to the left had side of the screen.
  4. In the Edit Field Criteria window select the Operator Begins with and enter the specific value.
  5. Click OK
  6. Click Next
  7. On Output tab, select to include any fields on the Output tab that should show in the results.  For example Vendor>Vendor name
  8. Click Next to the progress to the Sort tab
  9. Select Vendor, Vendor Name to sort alphabetically by Vendor name
  10. Select the Results to view the results