How do I create a query for a list of account numbers, student numbers or last names?

+1 vote
29 views
asked Mar 4, 2015 in How To by Admin
reopened Dec 25, 2018 by yczehn
How do I create a query for a list of account numbers, student numbers or last names?

1 Answer

answered Dec 25, 2018 by yczehn
 
Best answer

Go to the General Info tab under the query screen.

Choose the field you want to query on (1). You can any or all of the following filters.

Text (2): Enter any text or a single account number. You can use the Like wildcards (%).

Multiple Values (3): You can enter on every line a single text to query. So if for example you want to query for 10 accounts you enter all of them one on each line.

Value Between (4): Let’s say you to query all accounts until letter L; you just enter an L in the second box. Later when you want to query from L you enter an L only in the first box. If you want between F and L, you fill in both boxes.

 

 

Let's Welcome our New Members

  • blschwartz of Yeshiva Bais Binyomin - Mar 18, 2019

  • Nlink of Yeshiva Bais Binyomin - Mar 18, 2019

  • yachet of Beth Jacob of Boro Park - Mar 13, 2019

  • Shalom of Cong. Noiam Mgodim - Mar 12, 2019

  • mosdosbelz of Mosdos Belz - Mar 11, 2019

  • YosefAltman of Belz LAkewood - Feb 27, 2019

  • mlipschutz of YTT - Feb 19, 2019

  • gz of Bobov 45 - Feb 18, 2019

  • S. Bayer of Bais Malka Monsey - Feb 14, 2019

...